Measures not working for Chart Visual

[PK_PBIBoss]

I need to display top 10 Products for the Year on the cards and it changes randomly so I have created a Rank Measure but i am unable to use under visual filter and add the Category/Product Name as well. Any idea 

[Ashish_Mathur]

Hi,

Drag the Rankx measure to the filter section and select Less than equal to 10.  Create a Table visual and drag products and revenue there.

[PK_PBIBoss]

I know Table filters work but for Card the Visual filter does not work with the Measure.... As I need to place 10 cards and it needs to change dynamically as per the year basis and matrix dont give the same impact.....

[amitchandak]

@PK_PBIBoss , try Top N

https://databear.com/power-bi-dax-topn-function/

[PK_PBIBoss]

Thanks for responding @amitchandak but that is also a measure that will not work in the chart visual filter.... I want to place 10 cards each displaying one rank ( i.e. Rank 1 or Rank 2 or Rank3 ...) and once the year slicer is change these chart change the products accordingly.... 

[v-juanli-msft · Accepted solution]

Hi @PK_PBIBoss 

Add measures in card visuals

rank = RANKX(ALLSELECTED('Table 2'),CALCULATE(SUM('Table 2'[sale])),,DESC,Dense)

top1 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=1))

top2 = CALCULATE(MAX('Table 2'[product]),FILTER('Table 2',[rank]=2))

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.