Forum Discussion

thedocs's avatar
thedocs
Helper I
3 years ago
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...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Because of the row context in the visual.  For that row in the visual, the distinctcount of that Customer will be 1 itself.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

Try these measures

Total = SUM('Name'[countid],'Name'[Index]
Measure = calculate([Total],topn([Top qty],all('Name'[Merchant]),[Total]),values('Name'[Merchant]))

Hope this helps.