Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have created this graph and a slicer with the same measures. Now I want to control with the slicer the measures. So I want to select for instance actual cumulative and target cumulative so that only these will show in the graph like they are now showing in the graph 1
Graph1
Example DAX of 1 measure I created
Hi @PrinceII
Is your issue solved?
If the issue has been solved, please adopt the solution to help others.
Thanks!
If you still have some question, please don't hesitate to let me known.
Best Regards,
Link
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!
@PrinceII So typically you would have a disconnected table for you slicer and then do something like:
Measure =
VAR __Selected = 'SlicerTable'[Measures]
RETURN
IF("Measure" IN __Selected,
<calculation>,
BLANK()
)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |