Forum Discussion

Paddhof1984's avatar
Paddhof1984
Helper III
9 years ago

Divide Measures

Hello dear PowerBI community,   I do need your help regarding a calculation i want to do with 2 created measures:   I do have 2 measures:   TO2016 cumul.    and   TO2017 cumul.   These 2 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Paddhof1984,

 

So you want to hide the blank records which not exists in 2017, right?

If this is a case, you can try to use below formula:

 

Dev. vs. Cumul= if(ISBLANK([TO2017 cumul.])=FALSE(), DIVIDE([TO2017 cumul.]-[TO2016 cumul.],[TO2016 cumul.],0))

 

 

Regards,

Xiaoxin Sheng

Paddhof1984's avatar
Paddhof1984
Helper III
9 years ago

Anonymous

 

Hello,

 

somehow, when I add the the turnover from my tables to a splitted bar chart, the procentual change over the year differs to the one from my measuers ([GT 2016]-[GT 2017])/[GT 2016].

 

Here's my sample file, maybe you can tell me, why there's a difference between the shown values and the values calculated by the measure:

 

https://1drv.ms/u/s!AgBF1Ha5yWKVj4g61jARhrEfUEKYQQ

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Paddhof1984,

     

    I double check on previous sample file and found that it has the same result on my side.
    Notice: I create a new measure to store the new calculated formula, 'dev vs cumul 2016' is your original measure.

     

     

    Regards,

    Xiaoxin Sheng