Forum Discussion

Power_MN's avatar
Power_MN
Icon for Helper I rankHelper I
5 years ago
Solved

Measures for table visual - select value from table visual - ignore grouping of table visual

Hello everyone,

 

I'm facing a problem, that I can't solve.

You can find a sample-file by following the link to my OneDrive (in the file you can find a description, too):

 

https://1drv.ms/f/s!Aosv7ECDrc5dtzw5Im5Azt0L0cVL

 

1) I have make a ranking and display this in a table visual. Now I want to select and display the first place of this ranking for each region in a other table visual.

 

2) I have another measure. I want to display it in the same table visual as "1)". But this time it shouldn't filtered/grouped by the regions. It should show one value (the "total" average of revenue) over all regions (-> so it shows the average of revenue of one country - not of all individual regions)

 

Thank you for your help!

Kind regards

Michael 

DAX
Table Visual
  • Anonymous's avatar
    Anonymous
    5 years ago

    For the first requirement, all you need to do is filter by Rank and set Rank = 1 as shown below:

     

    As for the second requirement, I don't believe it is possible to display it the way you want: one figure over the whole table. The right way to go about this is to just add a card visual to display the average revenue. If you have a fixed number of rows in your table, then you can alignt the card visual with the table visual to make it look it is one single table.

  • Anonymous's avatar
    Anonymous
    5 years ago

    For the last column, you can use the below measure:

    RankOfCustomerB = CALCULATE([Rank Costs],ALL(Tabelle[Customer]),Tabelle[Customer]="B")
     
    I assume you want the Rank of Customer B in terms of Cost. If you want it in terms of Revenue, then just replace [Rank Costs] with [Rank Revenue]

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    For the first requirement, all you need to do is filter by Rank and set Rank = 1 as shown below:

     

    As for the second requirement, I don't believe it is possible to display it the way you want: one figure over the whole table. The right way to go about this is to just add a card visual to display the average revenue. If you have a fixed number of rows in your table, then you can alignt the card visual with the table visual to make it look it is one single table.

    • Power_MN's avatar
      Power_MN
      Icon for Helper I rankHelper I
      5 years ago

      Anonymous thanks, that works for me!


      Now I want display in the same table visual to every region only the rank of Customer B like this:

       

      Region  Customer  A of. Costs  Rank of B

      A              A                 20.67          3

      B              C                    9              2

      C              B                 14.50          1

       

      So I can monitor Customer B and can recognize, how he performs in contrast to the first place of Evers region 

       

      Thank you for your help!

      Kind regards 

      Michael

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        For the last column, you can use the below measure:

        RankOfCustomerB = CALCULATE([Rank Costs],ALL(Tabelle[Customer]),Tabelle[Customer]="B")
         
        I assume you want the Rank of Customer B in terms of Cost. If you want it in terms of Revenue, then just replace [Rank Costs] with [Rank Revenue]