How to get the correct measure total?

njxfoster — Thu, 28 Mar 2024 16:45:17 GMT

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!

Re: How to get the correct measure total?

Anonymous — Fri, 29 Mar 2024 02:57:26 GMT

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.

topic How to get the correct measure total? in DAX Commands and Tips

How to get the correct measure total?

Re: How to get the correct measure total?