Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Wrap it with COALESCE, so
Disorders =
SUMMARIZE(
Assessment,
Assessment[User ID],
"Count of Disorders",
COALESCE([Total Disorders],0)
)
It returns the first non-blank value so 0 if [Total Disorders] is blank.
It avoids the type conversion from the old +0 trick.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingWrap it with COALESCE, so
Disorders =
SUMMARIZE(
Assessment,
Assessment[User ID],
"Count of Disorders",
COALESCE([Total Disorders],0)
)
It returns the first non-blank value so 0 if [Total Disorders] is blank.
It avoids the type conversion from the old +0 trick.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you so much!
This fixed it.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
86 | |
46 | |
28 | |
21 |