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.

thedocs's avatar
thedocs
Helper I
3 years ago

Hi Ashish,

thank you very much for taking the time to reply.

 

In your .pbix you have defined the top customers. I already have a measure that does this called Rank. In my pbix example I am trying to calculate the total number of Top Ranked Customers /2 then pass this result to the measure (Flag Qty).

 

Basically in my .pbix I need to:

 

Replace

Total Customers to View = 6

 

With

Total Customers to View = (total customers /2)

 

This measure will need to work with ‘Flag Qty’ which I can then use to filter the result. I need to use the existing Rank measure as there is no BOTTOMN in DAX.

many thanks again,

Connor

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

If you want the Bottom n customers, then try this

Measure = calculate([Total],topn([Top qty]/2,all('Name'[Merchant]),[Total],ASC),values('Name'[Merchant]))