Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to achieve this simple formula within Power BI

How can I calculate this approach at PBI, I want to calcualte a Yield. The result schould appear at a KPI.  Thanks in Advance =(SUM(F3:F5)-SUM(G3:G5))/SUM(F3:F5)
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

 rajulshah 
any help is appreciated, the single Sums are right but a soon as I divided the numbers I receive a NaN.

rajulshah's avatar
rajulshah
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Anonymous 

 

Please use the following DAX measures:

Measure = 
DIVIDE ( COUNT [ CoulmnA ] - COUNT [ ColumnB ], COUNT [ CoulmnA ], 0 )

 

Please let me know if this didn't help.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    No sorry rajulshah , its not working. the expected result should be..

    without Filter = 94%

    Filter Month = 2 = 97%
    Filter Month = 3 = 93% 

    • rajulshah's avatar
      rajulshah
      Icon for Resident Rockstar rankResident Rockstar
      3 years ago

      Anonymous ,

       

      Please use following DAX:

      Measure =
DIVIDE (
    SUM ( 'Table'[CounterA] ) - SUM ( 'Table'[CounterB] ),
    SUM ( 'Table'[CounterA] )
)

       

      I got the following value:

      Please let me know if this didn't help.

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hey, rajulshah thanks for your assistance! But sorry I still receive a wrong value. I get the same result for each Row, even if CounterA & CounterB is 0.  Its really strange...