HASONEFILTER Quesion - DAX Help (Show results when slicers have been used.)

[Anonymous]

What is the proper way to apply (write) a DAX statement that will allow me to only show results in the data visualization, only when a user has selected 2 specific slicers.

i.e. Show dashboard as blank unless Client Name and Campaign Name have been selected.

Thank you.

[TomMartens]

Hey,

this little DAX statement should do what you are looking for

IF(
AND(HASONEVALUE('tablename'[Client Name]), HASONEVALUE('tablename'[Campaign Name]))
,[your measure]
,BLANK()
)

Hopefully this is what you are looking for

Regards

Tom

[Anonymous]

@TomMartens

Thanks for the help.  I think this along the lines of what I want.  

Where I need some help is understanding the "your measure" part.

In this case, I simply want to show the data visualizations as blank UNLESS the two slicers have been used.

Thanks again.

[v-chuncz-msft]

@Anonymous,

You may also take a look at ISFILTERED Function. Any further question, feel free to share us more details.

[TomMartens · Accepted solution]

Hey,

maybe my DAX statement has been a little short 🙂

So, assuming you want to show the sales amount from your sales table, you have to create a measure that returns nothing if both slicers do not have a single selection, otherwise return sales amount. Now you to create a measure like so

Sales Amount for viz = 
IF(
AND(HASONEVALUE('tablename'[Client Name]), HASONEVALUE('tablename'[Campaign Name]))
,SUM('sales'[Sales Amount])
,BLANK()
)

Please be aware that you have to create a measure for each value that you want to visualize and  that is dependent of a single selection of both slicers.

Hopefully this clarifies my previous post a little.

Regards

Tom