Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi there,
I recently ran into the following issue. My team has since resolved it (included) but we don't know 'why' it is the resolution.
The ask: Calculate a Distinct Count of Values where the Primary Key IN a list of PK's defined by a subquery.
The strange thing is, that when we ran the subquery through DAX Studio by itself, it returned the expected results.
Thank you for taking a look!
The DAX that WORKED:
VAR _subq =
The DAX that DID NOT WORK:
VAR _subq =
Solved! Go to Solution.
Hi @prill22ta ,
Using a single column argument, ALL returns all the unique values of the column.
CALCULATETABLE (
ALL( table[field] ),
table[field2] = "Yes"
)
So this statement returns the unique value of the table[filed] column, and the following table[filed2]="Yes" does not play a filtering role for the previous statement, because the ALL function ignores all filters
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @prill22ta ,
Using a single column argument, ALL returns all the unique values of the column.
CALCULATETABLE (
ALL( table[field] ),
table[field2] = "Yes"
)
So this statement returns the unique value of the table[filed] column, and the following table[filed2]="Yes" does not play a filtering role for the previous statement, because the ALL function ignores all filters
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Both versions are a measure.
For the first dax code, is it a measure? what filter context does it have?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
20 | |
20 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
24 | |
24 | |
22 |