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]))