Forum Discussion

dashbuilder's avatar
dashbuilder
New Member
5 years ago
Solved

Measure is calculated incorrectly in a table

Hi all, I would appreciate it if someone could help me please with my measures: I have the following table: Date Item Price 01.01.2020 A 20 01.01.2020 A 25 01.01.2020 A 30 0...
Need Help
dashbuilder's avatar
dashbuilder
New Member
5 years ago

amitchandak thank you for your response. I have created a new data table as follows

Then, I altered the formula as suggested:

Percent Growth = 
var _max = maxx('DATE','DATE'[Date])
var _min = MINX('DATE','DATE'[Date])
return
DIVIDE((CALCULATE(AVERAGE(Table[Price]), FILTER(ALLSELECTED('DATE'),'DATE'[Date]=_max))
-CALCULATE(AVERAGE(Table[Price]),FILTER(ALLSELECTED('DATE'),'DATE'[Date]=_min))),
CALCULATE(AVERAGE(Table[Price]),FILTER(ALLSELECTED('DATE'),'DATE'[Date]=_min)))*100

Now, I get "0"s:

Am I doing something wrong? Thank you heaps.