Forum Discussion
DAX when slicer is not selected then null
I have a direct query to my data set yet I need the follwoing:
When there is no value selected in the slicer for example when there is no date selected or there is no customer number selected then my table should rest in null and only show values if the user selects a date and a customer number.
Thanks
Assuming you have a date slicer and a customer number slicer, and you want your table to show values only when both a date and a customer number are selected, you can create a measure that checks if the slicers have selections and then display the values accordingly.
Here's an example of how you might structure your DAX measure:
YourMeasure =
IF (
ISFILTERED('DateTable'[DateColumn]) && ISFILTERED('CustomerTable'[CustomerNumberColumn]),
-- Show your values here when both slicers are selected
SUM('YourDataTable'[YourValueColumn]),
-- Show null when either or both slicers are not selected
BLANK()
)In this example:
- 'DateTable'[DateColumn] and 'CustomerTable'[CustomerNumberColumn] are the columns from your date and customer tables that correspond to the slicers.
- 'YourDataTable'[YourValueColumn] is the column in your data table that you want to display when both slicers are selected.
This DAX measure checks if both slicers are filtered (ISFILTERED function) and, if so, displays the sum of your values; otherwise, it displays BLANK().
You can adjust this DAX code based on your specific data model and column names. Remember to replace the placeholder table and column names with your actual table and column names.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.
1 Reply
- 123abc
Community Champion
Assuming you have a date slicer and a customer number slicer, and you want your table to show values only when both a date and a customer number are selected, you can create a measure that checks if the slicers have selections and then display the values accordingly.
Here's an example of how you might structure your DAX measure:
YourMeasure =
IF (
ISFILTERED('DateTable'[DateColumn]) && ISFILTERED('CustomerTable'[CustomerNumberColumn]),
-- Show your values here when both slicers are selected
SUM('YourDataTable'[YourValueColumn]),
-- Show null when either or both slicers are not selected
BLANK()
)In this example:
- 'DateTable'[DateColumn] and 'CustomerTable'[CustomerNumberColumn] are the columns from your date and customer tables that correspond to the slicers.
- 'YourDataTable'[YourValueColumn] is the column in your data table that you want to display when both slicers are selected.
This DAX measure checks if both slicers are filtered (ISFILTERED function) and, if so, displays the sum of your values; otherwise, it displays BLANK().
You can adjust this DAX code based on your specific data model and column names. Remember to replace the placeholder table and column names with your actual table and column names.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.