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.
I have attached a .pbix which will make it clearer
https://drive.google.com/file/d/16XQ7j8LNsi2KMeKZsYSkGp8mJGyawb0e/view?usp=sharing
What I need is to replace ( Total Customers to View = 6 )
With ?? Total Customers to View = Calculate(DISTINCTCOUNT('Leads'[Customer Name])/2
So result will be same with 6 passed to the second measure
Hi,
PBI file attached.
Hope this helps.