Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Convoluted Dax Counter

I have a situation where I have to create a variety of different counters.    I need counters that does this: 1) For every MP, count Location 1. 2) For every MP, count Location 2. 3) For [Locati...
Need Help
ntaylo06's avatar
ntaylo06
Icon for Resolver II rankResolver II
7 years ago

1) MP and L1 Counter = CALCULATE(COUNTA('Table'[Location 1]), NOTBLANK('Table'[MP]) + 0

2) MP and L2 Counter = CALCULATE(COUNTA('Table'[Location 2]), NOTBLANK('Table'[MP]) + 0

3) MP Group and L1 Counter = CALCULATE(COUNTA('Table'[Location 1]), NOTBLANK('Table'[MP], NOTBLANK('Table'[Group]) + 0

3) MP Group and L2 Counter = CALCULATE(COUNTA('Table'[Location 2]), NOTBLANK('Table'[MP], NOTBLANK('Table'[Group]) + 0

 

Let me know if I missunderstood.