Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Folks
I created a measure to count how many Overdue projects appear in a list
Does anyone have any tips for telling the measure to return Zero instead?
Solved! Go to Solution.
Wrap your function with COALESCE.
So COALESCE([Your Measure], 0)
COALESCE returns the first non-blank value, so if Your Measure is blank, it will default to the 0.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingPerfect Solution
Thank You!
Wrap your function with COALESCE.
So COALESCE([Your Measure], 0)
COALESCE returns the first non-blank value, so if Your Measure is blank, it will default to the 0.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting