Forum Discussion
Solved
Max Based on Category
Hi experts, i need to create 2 simple measure need help!!! Below Measure 1: Its actually max value of taget for each city partition by conusmer segment. Measure 2: It is name of segment which g...
Hi,
Please find attached the PBI file.
Hope this helps.
Hi Nobie
Would something like this work?
Measure1 =
CALCULATE(
MAX( 'Targets'[Target] ),
ALLEXCEPT( 'Targets', 'Targets'[City] )
)
Measure2 =
CALCULATE(
MAX( 'Targets'[Customer Segment] ),
FILTER(
ALLEXCEPT( 'Targets', 'Targets'[City] ),
'Targets'[Target] = [Measure1]
)
)
Not working
Do you have additional columns besides the 3 in your example?
If so, can you show the following?
1) Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...2) Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/14475233) Please explain how you would expect to get from step 1 to 2.
My pbix: Max Based on Category.pbix
I hope this helps.
Hi Nobie
Maybe try this
Measure1 = CALCULATE( MAX( 'Targets'[Target] ), ALL( 'Targets'[Customer Segment] ) ) Measure2 = CALCULATE( MAX( 'Targets'[Customer Segment] ), FILTER( ALL('Targets'[Customer Segment], 'Targets'[Target] ), 'Targets'[Target] = [Measure1] ) )