Hi i am stuck on this problem from past few days. my table looks like the one below.
Here i have Service No, Date and Count for Service No.
The formula i used to Count Service No is =Count ( [ Date ] ) In ( [ Service No ] )
in above table Service No have repeating values based on different date.
so now i was suppose to show Service No with most recent Data avoiding all duplicate vale.
So i created 2 variable
1. Var_RankingNumber: =Rank ( [ Date ]; ( [ Service No ] ;[ Date ) ;[ Service No] )
2. Var_RankingString : =FormatNumber ( [Var_RankingNumber] ;"#" )
Then on screen level filter i made Var_RankingString equals to 1. Which gave me the table below
Until now everything works fine for me and i was able to filter Service No based on most recent date.
My problem is with Count Service No where i want my table to like the table below
I want to include the original count of all the Service No as it was before hiding the duplivate vale.
Please guide me what should i do to get the desired results .
Thank You