Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a source table that is filtered by a time slicer.
What I what to know is whether it's possible to create a measure that uses data from that source table, but not filtered by the slicer (i.e. to be like the original source). So, I need some of the measures to use the filtered source, and some of them not to depend on the slicer selection.
Thanks in advance 🙂
Solved! Go to Solution.
Hi @CloserMKD,
According to your description, you should be able to create the measure using ALL Function (DAX) which removes all filters from the specified table.
In effect, ALL(Table) returns all of the values in the table, removing any filters from the context that otherwise might have been applied. For more details about ALL function, please refer to this article.
Regards
Hi @CloserMKD,
According to your description, you should be able to create the measure using ALL Function (DAX) which removes all filters from the specified table.
In effect, ALL(Table) returns all of the values in the table, removing any filters from the context that otherwise might have been applied. For more details about ALL function, please refer to this article.
Regards
Hi @CloserMKD
Please share some data and actual output expected.
Cheers
CheenuSing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |