Forum Discussion

Helper II

2 years ago

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 gives max values.

Note : Here Target is a calculated measure not directly coming from database.

Please let me know any dax function which can help to achieve,
thanks.
Please use the PBIX=> pbix

General Comment

Interesting Links

Tips and Tricks

Ashish_Mathur
2 years ago
Hi,

Please find attached the PBI file.

Hope this helps.

related_relatedtable.pbix4.5 MB

6 Replies

Ashish_Mathur
Super User
2 years ago
Hi,

Please find attached the PBI file.

Hope this helps.

related_relatedtable.pbix4.5 MB
gmsamborn
Super User
2 years ago
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] ) )
- Nobie
  Helper II
  2 years ago
  Not working
  - gmsamborn
    Super User
    2 years ago
    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/1447523
    
    3) Please explain how you would expect to get from step 1 to 2.
    
    My pbix: Max Based on Category.pbix
    
    I hope this helps.

Related content