Why does my KPI show 0 for Discount Band?
0
The AI review says my 'Total Discount Band' KPI is invalid. Why is it 0?
1 answer
0
Accepted answer
Discount Band is a category (None, Low, Medium, High), not a number, so summing it gives 0. Remove the card, or count rows per band with a donut chart instead.
More detail: DAX measures and calculated columns
Your answer
Know the answer? Sign in to help. It's free.