Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help please ! - MultiCard KPI show top customer per category problem

Hi,

I have a multi-row card visual. Aside from below metrics, I want to be able to display top customers in rank by category using only one measure.

 

But what I created was three sets of measures with  formula basis of:

Top Customer Adaptive Mobility =
VAR temp_table =
SUMMARIZE (
ALL ( 'Main Table'[Customer_Name] ),
'Main Table'[Customer_Name] ,
"SalesTotalValue", [Adaptive Statistic]
)
RETURN
CALCULATE (
MAX ( 'Main Table'[Customer_Name] ),
FILTER(
ADDCOLUMNS ( temp_table, "Rank", [TieBreaker AM Customer Name] ),
[Rank] = 1
), filter('Main Table','Main Table'[Plan_Variant_Group] = "Adaptive Mobility"))
 
That is, when I include the three of them in the values for the visual, Adaptive Mobility wil have value of blank for Top Customer Business Mobile Plan (which is understandable). 
 
My goal is to distinctively show top customers per plan category without displaying the other measures taht are not applicable for a specific category
 
To illustrate, I dont want to see this:
 

 

Those highlighted in red are not applicable for that category. I want to be able to eliminate those either by hiding it or by creating a measure. 

 
 
  • You won't be able to alter the title, but you could try: 

     

    Top Customer = SWITCH( SELECTEDVALUE( 'Main Table'[Plan_Variant_Group] )

    ,  "Adaptive Mobility", [Top Customer Adaptive Mobility]

    , "BMP", [Top Customer BMP]

    )

     

    etc

2 Replies

  • AllisonKennedy's avatar
    AllisonKennedy
    Icon for Community Champion rankCommunity Champion

    You won't be able to alter the title, but you could try: 

     

    Top Customer = SWITCH( SELECTEDVALUE( 'Main Table'[Plan_Variant_Group] )

    ,  "Adaptive Mobility", [Top Customer Adaptive Mobility]

    , "BMP", [Top Customer BMP]

    )

     

    etc

    • Anonymous's avatar
      Anonymous
      Not applicable

      Yes, I was able to mark it as the correct solution