Forum Discussion

PK_PBIBoss's avatar
PK_PBIBoss
Frequent Visitor
6 years ago
Solved

Measures not working for Chart Visual

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 

 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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.

5 Replies

    • PK_PBIBoss's avatar
      PK_PBIBoss
      Frequent Visitor
      6 years ago

      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's avatar
        v-juanli-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    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's avatar
      PK_PBIBoss
      Frequent Visitor
      6 years ago

      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.....