I'm struggling to create a formula that can give me a % result when filtered by any combination of three other columns.
Here is a mockup of my table:
And here are some examples of the results I want to formula to show:
I feel like this should be simple but I've tried a few different things and so far no luck.
Do I need to create multiple formulae e..g one for Location and one for Month, or is it possible to do all in one?
Go to Solution.
Try a measure like this
View solution in original post
Amazing, thank you!
Plugged the formula in and suddenly my charts are making a lot more sense 🙂
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!