Forum Discussion
Calculate based on Slicer Selection
Hi y'all, thanks for your efforts but i sovled this the other day using variables.
E
Hey, amitchandak
Under the tab "SoUAR FY Development" I've started working on it, the formula "SoUAR FY Dev 2" was my attempt, you can see it's supposed to calculate and sum up Sum of USD Amount Rollup. The purposes with this formula is to create a Full Year Estimate so I've nested the calculate function with a second calculate function to include all months (the data is only monthly and not daily) but as you can see in the headers it doesn’t aggregate the values from the current forecast (See Current Forecast Version i built to identify which is the current forecast), I've built another measure where I don't use all months and it limits the data to the YYYY and MM selected in slicers. Any calculate function you can build which just evaluates and filters the current forecast from the Scenario Description column for the point in time selected by the users in slicers would be super helpful!! Sorry but I'm having issues attaching the PBI file to the message, would you mind shooting me an email at XXXXXX and I'll share with you a sample file.
Appreciate your efforts mate, E
Hi 2w ,
Could you please share the sample pbix and the sample output through OneDrive for Business?(Please mask any sensitive data before uploading)
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
