Backlog forecast allocation DAX formula

[Harsh]

Hello @Rachid,

You’re Welcome!

I’m glad that I was able to assist you.

This technique is a consolidation of various concepts coming together so I’m not sure it’s covered in any of our previous videos as of now. Just few days back I covered and explained this technique to other forum member. Below is the link of that post provided for the reference.

Thanks and Warm Regards,
Harsh

Measure branching OR variables in a larger measure

Hello @Timmay, Thank You for posting your query onto the Forum. Firstly, let’s understand why you’re getting the wrong results in your large measure and then we’ll see how we can convert those 3 measures into one consolidated measure to achieve the same results. So in your large measure, the first mistake which you had made is referencing a naked variable inside a “CALCULATE()” function. You cannot use/reference/call a naked variable directly inside CALCULATE since variables are considered as…