Forum Discussion
joshua1990
Post Prodigy
Post ProdigyDisabling Measure when selecting multiple filters
Hi experts, I have a simple measure that counts the Sales for the past 2 weeks. On the top of the report I have a slicer/ filter to select the weeks. Is there any chance to get a 0 value when s...
Hi,
You can accomplish for example by using HASONEFILTER. e.g.IF(HASONEFILTER('Calendar'[Week]),[Measure],0)
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Hey,
If you do not want to change Slicer selection settings, maybe amend measure.
So If filter selection HASONEVALUE, then show, else 0
ValtteriN
Community Champion
Community Championjoshua1990
If you use a hierarchy + single select this should work by referencing the Week column. E.g.
Value1 = if(HASONEFILTER('Calendar'[This week]),1,0)
joshua1990Post Prodigy
Post ProdigyThe slicer has to have the multiple selection option activated. Single selection as an option is not possible
- ValtteriN
Could you share a screenshot of the issue? This method should also work with multiselect: