Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have DBTECH as the dimension on my bar chart. It displays % completion for each DBTech. The data for DB2LUW has no status=COMPLETED . i am trying to have the Bar chart display 0% for DB2LUW. Please suggest how I can achieve this
I have below expression in the chart
Num(
Count({<[Status]={"COMPLETED"}>}[Status])
/
Count({<[DB Tech]={"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#.%')
If you use one of the RangeSum/RangeAvg functions, it should replace your NULL value with a zero. Just wrap your function in one of them:
RangeSum(
Num(
Count({<[Status]={"COMPLETED"}>}[Status])
/
Count({<[DB Tech]={"SQL","ORACLE","DB2-LUW"}>}[DB Tech])
, '#.%')
)