Forum Discussion

Frequent Visitor

2 years ago

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

New Member

2 years ago

Follow steps:

1. Replace Value '0' to 'null'.

2. Create a New Measure

Measure = IF( SUM('Table'[Value]) = 0, CALCULATE(AVERAGEA('Table'[Value]), REMOVEFILTERS('Table'[Customer])), SUM('Table'[Value]) );