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.
Hi,
Trying to see how to write the query implement if the filter has value selected or if its not selected (meaning ALL is selected) then how to apply or not apply the filter.
Example
Solved! Go to Solution.
@csinusa , You can not use slicer value in calculated table.
If this a var of meausre you can try like
TREATAS ( allselected('Date'[Calendar Year]), 'Date'[Calendar Year] )
Actually I m creating paginated version of report using powebi desktop dataset and using DAX queries to get data. My desktop report has no issue selecting/ignoring parameters from dropdownlist but my paginated report makes me select values in all parameters.
So if I have customer / locations / sites , it is possible the user only want to run the paginated report by customer but if decided to run for one location, then he will select location as parameter otherwise we want to pass as null or all for both location and sites parameter.
Thats what the issue how to set the filters in DAX when passed and not set when not passed.
The customer, location and sites are all in dropdownlist
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |