Forum Discussion
NikNithiy
Helper I
Helper IMatrix/Table Visual - Show Blank Values as Zero
Hi Team, I want to just show the blanks as zero in my table/matrix visual. But when i add a zero at the end of measure it is getting drill down and showing unwanted results means the data behind(fil...
Syk
Resident Rockstar
Resident RockstarTry using the COALESCE function. This will get the first non-blank value so just pass a 0 as the second argument.
https://learn.microsoft.com/en-us/dax/coalesce-function-dax
NikNithiyHelper I
Helper II was not able to dervice this can you please tell me how use the coleasce to this measure "calculate(Tab1[count(id)],filter([tab2],tab2[area]="123"))"