topic Re: How to Count occurrences based on other columns in DAX Commands and Tips

How to Count occurrences based on other columns

mtb1973 — Fri, 15 May 2020 17:43:59 GMT

Hello, I am struggling to put together a formula that calculates how many times the combination of WC1 and Job Order Number occur per Family Code in the given context. In blue is what the count should be. Any assistance is greatly appreciated. Thanks

Re: How to Count occurrences based on other columns

AlB — Fri, 15 May 2020 18:09:27 GMT

Hi mtb1973

If a measure is what you want and you're going to use it in a table visual like the one you show, try this:

Measure = COUNTROWS ( CALCULATETABLE ( SUMMARIZE ( Table1, Table1[WC1], Table1[Job Order Number] ), ALL ( Table1[WC1], Table1[Job Order Number] ) ) )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers

Re: How to Count occurrences based on other columns

mtb1973 — Fri, 15 May 2020 19:32:26 GMT

Thanks, maybe I am misunderstanding something. I am trying to count how many distinct WC/Job combinations there are for for each distinct Famuly code.

Re: How to Count occurrences based on other columns

Anonymous — Sat, 16 May 2020 14:31:14 GMT

Hi mtb1973 ,

You can use the following measure.

Measure = CALCULATE(COUNT(Table1[WC1]),ALLEXCEPT(Table3,Table1[WC1], Table1[Job Order Number]))

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!