Forum Discussion
dynamic Max calculation
Hi Team,
Below is my data.
| Cust_ID | Priority | Country |
| 1234 | 1 | INDIA |
| 1234 | 2 | INDIA |
| 4567 | 3 | INDIA |
| 4567 | 1 | INDIA |
Country will be my filter and I want to create the pie chart where I want to show count of Cust_ID by priority but with business rule. For example: If user select INDIA from filter, then it should take max of priority by Cust_ID which is 2 and 3 respectively and pie chart show based on below data
| Cust_ID | Priority |
| 1234 | 2 |
| 4567 | 3 |
Hi VIPINGARG ,
Like this?Please create a new measure.
Count of Id = VAR _max_priority = CALCULATE(MAX('Table'[Priority]),ALLEXCEPT('Table','Table'[Cust_ID])) VAR _result = CALCULATE(COUNT('Table'[Cust_ID]),'Table'[Priority]=_max_priority) RETURN _resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
VIPINGARG So put Cust_ID in Legend and this measure, Measure = MAX('Table'[Priority]) as Values?
Greg_Deckler I can't use cust_ID as legend as I need to show it by Priority only and need to show the count of cust_IDs.
Hi VIPINGARG ,
Like this?Please create a new measure.
Count of Id = VAR _max_priority = CALCULATE(MAX('Table'[Priority]),ALLEXCEPT('Table','Table'[Cust_ID])) VAR _result = CALCULATE(COUNT('Table'[Cust_ID]),'Table'[Priority]=_max_priority) RETURN _resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
