Forum Discussion
How to replace the blank with zero in Matrix visual
Hi Team, amitchandak I have a dataset like below. For the above data I have to show Percentages. Requirement Is : there is no data for some zones, instead of Blank I have to show 0%....
This only not working
Percentage of project =
var a= COUNT(Sheet2[Project])
var b=CALCULATE(COUNT(Sheet2[Project]),ALL('Table'[Zone]))
var c=a/b
var d=SELECTEDVALUE(Sheet2[Zone])
return
IF(ISNONTEXT(d),0,c)+0
Result:
Result:
Hi MPC,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng