Prediction model - locking up a measure

[krzys]

Hi,

I have a problem with setting up a measure. I want to compare what was reported at a specific point in time with the final result.

I can have a proper measure for the result. It is done by sum(if( Date='4/8/2022')), but if I do that, such a measure cannot be used for different dates. Normally, I don't need to use it that way, but I would like to know how far the reported number was from the final result as a %.

On the left is the current state I have, which is an error for any other date different from 4/8/22. On the right side is the result I would like. I tried to use total, but this sums up GEOs, and I need the result by GEO.

Measure I want to compare: sum([USD])

Result measure : sum({<[Date]={'4/8/2022'}>}[USD])

Thanks in advance for all the innovative ideas

[MendyS]

hi 

if I got you - try this,
 sum([USD]) /  sum(TOTAL {<[Date]={'4/8/2022'}>}[USD])

[krzys]

Hey, I think you get me, but the total is not working. I tried this before 😞

It gives me 22.65, which is APAC + EMEA for the 4/8/2022 date

Result

[krzys]

adding the data too