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)
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")
Thanks. And like above, can you tell me how this gets applied relative to Greg_Deckler direction to include his measure in the Values slot?
Thank you both.
drop multil row card visual on canvas and in fields add this new measure "Label"
