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.
Hello everyone,
Hope you're all well.
I have a measure as below:
Solved! Go to Solution.
Hi @tamnguyenEPM ,
You can create a new table for slicer:
Then you can create the following visual level filter and add it to the visual you want to filter by slicer:
measure = IF(ISFILTERED('Table'[Value]),IF([ID-Print]>= MAX('Table'[left]) &&[ID-Print] <=MAX('Table'[right]),1,0),1)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @tamnguyenEPM ,
You can create a new table for slicer:
Then you can create the following visual level filter and add it to the visual you want to filter by slicer:
measure = IF(ISFILTERED('Table'[Value]),IF([ID-Print]>= MAX('Table'[left]) &&[ID-Print] <=MAX('Table'[right]),1,0),1)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
See my reply to a similar post here - Solved: Re: Grouping data together - Microsoft Power BI Community
You must create either a calculated column in DAX or a custom column in Power Query. Measures always only have 1 value so even if you could add it to a slicer it would be one value. They only seem to have multiple values because they recalculate different ways depending on the filter context, say rows in a table visual, or per the axis of a bar chart.
And you cannot use ALLSELECTED in a calculated column. Calculated columns only calculate at refresh before any selections are evaluated so it will not return expected results, and user selection will do nothing.
Perhaps you can share some data and give us some screenshots of expected results.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingJoin the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
87 | |
80 | |
69 | |
69 |
User | Count |
---|---|
226 | |
129 | |
119 | |
83 | |
77 |