Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have some DAX given to me for another project that does a count on IDs in a dim against a fact table
CALCULATE (
SUMX (
VALUES ( 'Dim Proj'[Sub Proj ID] ),
1
),
'Fact Table')
However I have this date
Proj ID Sub Proj ID
1 1
1 2
1 3
2 None
And At the moment Nones are causing an issue. if I put it into a table 2s arent showing.
I want to be able to update the above DAX to show 0 if Sub Proj ID is none but I can't figure it out.
Can anyone help out with the DAX change?
Solved! Go to Solution.
Hi @DebbieE
Try this
Measure = IF(SELECTEDVALUE('Dim Proj'[Sub Proj ID]) = "None", 0,
CALCULATE( SUMX(VALUES('Dim Proj'[Sub Proj ID] ),1), 'Fact Table')
Regards
Phil
Proud to be a Super User!
Hi @DebbieE
Try this
Measure = IF(SELECTEDVALUE('Dim Proj'[Sub Proj ID]) = "None", 0,
CALCULATE( SUMX(VALUES('Dim Proj'[Sub Proj ID] ),1), 'Fact Table')
Regards
Phil
Proud to be a Super User!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
59 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |