How to get the correct measure total?

[njxfoster]

Hi Guys!

I want to make "Forecast to Actual % daily" total show total of 103.69(all combine) instead of 21.11

The calculation for "Forecast to Actual % daily" is  Call Received/Forecast

I am using measure:  Forecast to Actual % daily = divide(sum('Forecast%'[Call Received]),SUM('Forecast%'[Forecast]))

What changes I need to make on my measure so I can get the correct total for my data??

Thanks in advance!

[v-yilong-msft · Accepted solution]

Hi @njxfoster ,

I create a table as you mentioned.

Then I use your DAX code to create a Measure named Forecast to Actual % daily.

Forecast to Actual % daily =
DIVIDE ( SUM ( 'Forecast%'[Call Received] ), SUM ( 'Forecast%'[Forecast] ) )

I create a new measure and finally I get what you want.

Measure =
VAR _Div =
    DIVIDE ( SUM ( 'Forecast%'[Call Received] ), SUM ( 'Forecast%'[Forecast] ) )
RETURN
    IF (
        ISINSCOPE ( 'Forecast%'[SERVICE_NAME] ),
        _Div,
        SUMX ( 'Forecast%', [Forecast to Actual % daily] )
    )

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.