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?

amitchandak's avatar
amitchandak
Super User
4 years ago

jalaomar ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try like

Divide([Count of VSU fullfilment]*1.0, [Count Total])

jalaomar's avatar
jalaomar
Helper IV
4 years ago

Hi, 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]))
 
Was not able to provide sample data 
 
i tried your measure and it gave me an error as shown in the screenshot 
  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

    Change the [Count of SVU fulfillment] to

    Count of VSU fullfillment = CALCULATE(COUNTROWS('KPI'); FILTER('KPI'; [VSU 5 weeks]=1))

     

    Also, please provide the answers to the following:

    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,

       

      What should I change in the measure?

      Count of VSU fullfillment = CALCULATE(COUNTROWS('KPI'); FILTER('KPI'; [VSU 5 weeks]="1"))

       

      what does each measure in the DIVIDE function deliver in a card visual? 

      Count of VSU fullfillment measure is calculating the total number of rows that has the value 1 (1 is a string) 

      Count Total is a measure calculating the total number of rows in the table 

      Calculate margin% is calculating the % of projects that have the value 1 

       

      Value 1 is indicating that the project has managed to deliver a machine within 35 days (diff between 2 actual dates)

      Also what does the % measure deliver for the total row if added to the table visual?

      Count Total & Count of VSU fullfillment I will not visualize in the table, just wanted to verify that the measure is working properly 

      but Magin% i need to visualize as it is the KPI value to indicate the % of projects that has reached target.