Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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 October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
109 | |
98 | |
93 |