Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi @Anonymous ,
You can't use a measure in a slicer, only a column can. What you can do is to reference that measure in another measure to filter a calculation. For example:
New Measure =
CALCULATE (
[measure or aggregation],
FILTER ( mytable, mytable[column] = [my filter measure] )
)
If you want to get a better answer, please refer to this sticky post:
Proud to be a Super User!
HI @Anonymous
You cannot plug measures into slicers...only columns.
I'd suggest building the logic for a given selection of dates, calculate the measure for the intended dates. You will need a date table and it marked appropriately. But after that, there are Time Intelligence functions that will make this really easy.
Hope this helps!
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
105 | |
99 | |
99 | |
38 | |
37 |
User | Count |
---|---|
157 | |
120 | |
74 | |
72 | |
63 |