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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

dashbuilder , Create a separate date table and then try same formula with date table 

example - 

Percent Change =
var _max = maxx('DATE','DATE'[Date])
var _min = MINX('DATE','DATE'[Date])
return
(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

 

Also, use the divide function 

  • 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.