Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everyone,
I have created a measure that calculates the calendar weeks. How can I now use the measure as a slicer, since you can't just drag it over?
my measure looks like this:
measure =
var a = CALCULATE(SELECTEDVALUE(calendar[date]))
var b = WEEKNUM(a,2)
return b
is there a way to use a measure as a slicer?
thank you in advance
Solved! Go to Solution.
Hi @anlu20 ,
A measure can't be used in slicer directly. You can try this.
Create a column.
Column 2 = WEEKNUM(CALCULATE(SELECTEDVALUE('date'[date])),2)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
Hi @anlu20 ,
A measure can't be used in slicer directly. You can try this.
Create a column.
Column 2 = WEEKNUM(CALCULATE(SELECTEDVALUE('date'[date])),2)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards
Community Support Team _ Polly
Hi @anlu20 ,
Check if this video helps you to have the expected result.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |