Forum Discussion
Solved
Zero value as average
I have a table Which i want to show as Visualisation Table with zero value as average per product catagory. Expected visualization
pls try this
use if condition to achive this.
here is example:
AverageAmount =
IF(
SUM('YourTable'[Amount]) = 0,
AVERAGE('YourTable'[Amount]),
SUM('YourTable'[Amount])
)