cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Resolver II

Distinc count by record values

Hi,

hope someone can help me with the following:
Based on the table below, I want to calculate how often a certain combination occurs per unique MO_Monsternummer value?

concerns the combinations based on column "Categorie coli":

• 1 and 2
• 1 and 4
• 3 and 2
• 3 and 4

The result i'm looking for is this:

regards

ICTURION

1 ACCEPTED SOLUTION
Community Champion

A trickier solution to your tricky question,

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
5 REPLIES 5
Community Champion

A trickier solution to your tricky question,

 Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension! DAX is simple, but NOT EASY!
Resolver II

Hi CNENFRNL,

Is it also possible to calculate the numbers per category in a separate measure? I also want to be able to calculate with the different results per category. For example by dividing the number of category "1 and 2" by the number of category "1 and 4". so 2/5 = 0.4

Resolver II

thank you. I didn't realize the solution was so tricky

Super User

@icturion  can you please provide sample data in a table format?

Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
Resolver II
 MO_Monsternummer Categorie coli 123 1 123 2 234 1 234 4 345 3 345 2 456 1 456 4 567 1 567 4 678 1 678 4 789 1 789 4 789 3 789 2

Hi SMPA01, her is the sample data in a table format. Thank you

Announcements

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Power BI Monthly Update - May 2024

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

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors