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 query
= Calculate(DistinctCount(TableBColumn), TableBcolumnx=1,TableBcolumnxx=2,Filter(TableA, TableAColumnm=3)
)
= Calculate(DistinctCount(TableBColumn), TableBcolumnx=1,TableBcolumnxx=2, TableAColumnm=3
)
PROBLEM 2
Ok let assume I have a TableA and TableB with 
1 to many Relationship
I create new table from tableB ,let assume Table C = SummurizeColumn(TablebID,"MIN TEST",MIN(TablebColumnx),"MIN DEPLOYED",MIN(TablebColumnx)
Not the TableC have a relationship with B as Many to 1

= Calculate(DistinctCount(TableBColumnID), TableBcolumnx=B,TableBcolumnxx=2,Filter(TableC, TableCColumnm=3)
)
= Calculate(DistinctCount(TableBColumn), TableBcolumnx=1,TableBcolumnxx=2, TableCColumnm=3
)
I Hope someone will clarify to me
I tried them and different Result 
Thanks in advance

Interesting Links
Tips and Tricks

1 Reply

  • 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