How to achieve this simple formula within Power BI

[Fresh]

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)

[Fresh]

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

[rajulshah]

@Fresh 

Please use the following DAX measures:

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

Please let me know if this didn't help.

[Fresh]

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

without Filter = 94%

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

[rajulshah]

@Fresh ,

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.

[Fresh]

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... 

[rajulshah]

@Fresh , can you post the screenshot of the input data and what output you are getting?

Because I believe that you are plotting some other columns as we are not getting the context.

[Fresh]

I need (Sum(CountA) - Sum(CountB))/Sum(CountA)

Day	Month	CounterA	CounterB
26.02.23	2	120	3
27.02.23	2	0	0
28.02.23	2	119	5
01.03.23	3	120	8
02.03.23	3	1	0
03.03.23	3	119	9
04.03.23	3	121	10
05.03.23	3	0	0

[rajulshah]

@Fresh ,

Can you please provide us the sample data?

Power BI doesn't work as per the row numbers.