Forum Discussion
Solved
Filter on measure changes original values
In below example I need to see the top 14 using the Rank Measure. The value 14 is also a Measure. When I pass the measure to the Rank measure it afects the filter. How do I filter Top value when valu...
Because of the row context in the visual. For that row in the visual, the distinctcount of that Customer will be 1 itself.
That works a treat thank you 🙂 (but only when I pass a fixed value to the measure.)
Any idea why when I pass a calculated measure [Top Customers] to [Measure Top] it returns 1 row instead of the 11 that is calculated? How can I pass the total 11 not 1 row value?
Top Customers = DISTINCTCOUNT(Leads[Customer Name])/2
Measure Top = calculate([countleadid],topn([Top Customers],all(Leads[Customer Name]),[countleadid],DESC),values(Leads[Customer Name]))
Because of the row context in the visual. For that row in the visual, the distinctcount of that Customer will be 1 itself.