Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

CALCULATE CLARIFICATION

Hello Guys,, I just want only a clarification regarding this basic dax systax Ok let assume I have a TableA and TableB with  1 to many Relationship PROBLEM 1 What is the diff of these 2 dax ...
Interesting Links
Tips and Tricks
AlB's avatar
AlB
Community Champion
6 years ago

Hi Anonymous 

PROBLEM 1

The second statement is syntax sugar for: 

=Calculate(DistinctCount(TableBColumn), TableBcolumnx=1,TableBcolumnxx=2, Filter(ALL(TableAColumnm), TableAColumnm=3)
)

The only difference with the first one is the ALL, which overrides existing filters on TableAColumnm

PROBLEM 2

I don't quite follow. It would help if you can share the real example, pbix

 

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

Cheers  Datanaut