Count Filtered SUM Measure

Question

Hi,&nbsp;I have data in the following format:&nbsp;Date &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Reg &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Distance Miles20190101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Veh 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 020190101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Veh 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 020190101 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Veh 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12320190102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Veh 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120190102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Veh 1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 020190102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Veh 2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 020190102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; Veh 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 020190102 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Veh 3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp;Distance Miles is already a measure. What I need to do is to Count the number of Distinct 'Reg' where the sum of the 'Distance Miles' = 0&nbsp;So the answer above would be:20190101 &nbsp; &nbsp; 1 &nbsp; &nbsp; (Veh 1)20190102 &nbsp; &nbsp; 2 &nbsp; &nbsp; (Veh 2, Veh 3)&nbsp;Many thanks,

alb · Answer

Hi&nbsp;VendettaBob&nbsp;
1. Place Table1[Date] in a table visual
2. Place this measure in the visual
Measure =
SUMX ( DISTINCT ( Table1[Reg] ), INT ( [Distance Miles] = 0 ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers&nbsp;&nbsp;
&nbsp;
&nbsp;

vendettabob · Answer

Hi,&nbsp;Thanks for this. This would work in a graph with the date on the x axis.&nbsp;However, I also need this value in a tile. So would need to incorporate the date element into the calc. How would I do this?&nbsp;Thanks,

Forum Discussion

Count Filtered SUM Measure

2 Replies

Related content

Count Measure

Filter and Count

Filter participant counts

Counting nulls

Dynamic measure filtering