Distinc count by record values

[icturion]

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

[CNENFRNL · Accepted solution]

A trickier solution to your tricky question,

[icturion]

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

[icturion]

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

[smpa01]

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

[icturion]

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