Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good Morning, community. Here is my problem:
I have this slicer from Jan to Aug whereas each month has its own goal to be achieved, luckly from Jan to Jul the goal is the same, but in Aug the value changed.
So now I want to automaticaly change the goal accordingly with the selected(s) month(s). I kinda figured it out already, but now I'm struggling with this issue: When I select more than 1 month (August included) it only shows the SUM of the other months but not August
Exaclty same value if August is selected
August's goal
So I want to be able to detect if the August value was selected or not, so then the goal will be adjusted accordingly.
Btw, both goals are in the same Table but in different columns.
@marciomendonca , You check if august is selected
if( "August" in Values(Date[Month]), 1,0)
Check has one value to make sure one value is selected - https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Sadly, didn't work 😞
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |