Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Measures by classification

Hi Experts,

 

I have a question that struggle me for a time, would anyone can help me to solve?
I would like to create 4 measures (It's 2 types of measure in fact)

 

Please find the raw sample file for download

https://gbil-my.sharepoint.com/:u:/p/simon_chung/EeDrG4mY275IsXZCxPWAPsIBAVhcBqgydIfn0tkGvUTKOQ 

 

There is a CODE contains A, B and the others, in this case we will only focus on A & B. 

 

image.png

Customers will be classified into 
A only - Yellow
B only - Orange

Mixed: A - Green

Mixed: B - Blue

 

The expected result is to create 4 Measures to get the sum of A only, B only, Mixed: A, Mixed: B

Note the results will vary with the time of selection, so it is no way to create Column to solve.

 

Expected result:

image.png

 

The question looks simple, but it struggle me for a time really.

 

 

Many many thanks
Simon Chung

1 ACCEPTED SOLUTION

Hi,

You may download my PBI file from here.

Hope this helps.

Untitled.png


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

11 REPLIES 11

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.