Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Count Maximum Code based on Key in Summarized Table

Having a nightmare today, mind has gone blank (spending too much time on the one dashboard) I have a summarized table (code below) which brings back the following table when created. As you can see...
Need Help
  • Anonymous's avatar
    Anonymous
    9 months ago

    Hi Anonymous ,

    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
9 months ago

Anonymous , if you  want max of measure you need to create measure like 

 

Maxx(SUMMARIZE(
F_BALANCED_SCORECARD_METRICS,
F_BALANCED_SCORECARD_METRICS[TIMEFRAME],
F_BALANCED_SCORECARD_METRICS[COST_CENTRE_NUMBER],
F_BALANCED_SCORECARD_METRICS[LEVEL],
F_BALANCED_SCORECARD_METRICS[PERIOD_KEY],
F_BALANCED_SCORECARD_METRICS[KPI_KEY],
F_BALANCED_SCORECARD_METRICS[BRAG_COLOUR_F],
F_BALANCED_SCORECARD_METRICS[BRAG_CODE]) , [Your Measure]) 

if you need What is the category for max value you can use Index function 

 

example add more column as per need 

 

maxx(INDEX(1, ALLSELECTED('Item'[Brand]), ORDERBY([Gross], DESC) ), [Brand]) 

 

Top 2 = CALCULATE([Gross], KEEPFILTERS(TOPN(2,ALLSELECTED('Item'[Brand])
, [Gross],DESC)))

TOP = CALCULATE([Gross], KEEPFILTERS(INDEX(1, ALLSELECTED('Item'[Brand]),
ORDERBY([Gross], DESC))))


Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U