How to Count occurrences based on other columns

[mtb1973]

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

[harshnathani]

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!!

[AlB]

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 

[mtb1973]

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.