Forum Discussion

jalaomar's avatar
jalaomar
Helper IV
4 years ago
Solved

Divide function not giving right value

Hi all,   in a tabel I have several measures displayed and in one of the measures i would like to calculate the margin% but it seems to give wrong value.   44/50=88% any idea where i might be do...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Probably a filter context issue...
    What is the code for both measures and 
    what does each measure in the DIVIDE function deliver in a card visual? 
    Also what does the % measure deliver for the total row if added to the table visual?

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

Probably a filter context issue...
What is the code for both measures and 
what does each measure in the DIVIDE function deliver in a card visual? 
Also what does the % measure deliver for the total row if added to the table visual?

jalaomar's avatar
jalaomar
Helper IV
4 years ago

Hi,

I need to calculate how many projects that have fulfilled a certain criteria, all else is working well.

These are my measures 

VSU Days = DATEDIFF('KPI'[MIS3.1Actual 2];'KPI'[ITG4Actual2];DAY)

 

VSU 5 weeks = IF('KPI'[VSU Days] <=35; "1";"0")

 

PVoT Days = DATEDIFF('KPI'[ITG4Baseline2];'KPI'[ITG4Actual2];DAY)

 

ITG4 fullfillmentX = SWITCH(TRUE();

ISBLANK('KPI'[PVoT Days]);0;
'KPI'[PVoT Days]>=1;0;
'KPI'[PVoT Days]<=0;1;
0)
 

Count total = CALCULATE(COUNTROWS('KPI'))

 

Count of VSU fullfillment = CALCULATE(COUNTROWS('KPI'); FILTER('KPI';'KPI'[VSU 5 weeks]="1"))
 
calculate margin% = CALCULATE(DIVIDE('KPI'[Count of VSU fullfillment];'KPI'[Count total]))