Forum Discussion
DAX Help
Assuming that your calculation is a measure called "My Measure", then you could do this:
Measure = IF(HASONEFILTER(<columnName>),[My Measure],BLANK())
<columnName> you would replace on the column that you want them to filter/slice on.
Put this Measure in place of where you currently have your "My Measure" in your line chart visualization (Values area most likely)
Generally you handle this with a measure in the format:
Measure = IF(HASONEFILTER(<columnName>),<calculation>,BLANK())
In this case, the output in the Line Graph is already a calculation I have created. Does this impact the solution?
Also, can you be a little more explicit in how and where this "new" measure is applied?
Thanks.
Assuming that your calculation is a measure called "My Measure", then you could do this:
Measure = IF(HASONEFILTER(<columnName>),[My Measure],BLANK())
<columnName> you would replace on the column that you want them to filter/slice on.
Put this Measure in place of where you currently have your "My Measure" in your line chart visualization (Values area most likely)
Perfect, thanks.
One last question. Is there a way to display a message, when the condition hasn't been met (slicer used).
Such as, "Select Campaign Name to see results"?
Thanks again!
create another measure to show label.
Label = IF(HASONEFILTER(Table3[Category]),"", "Select Campaign Name to see results")
