Forum Discussion
Help with slicer applying to measure
I can't seem to understand how to get the right filter context to apply the selected two slicers to the measure in the visual. I think I need to use the ALLSELECTED and RELATED to get the measure to only have the two slicer filters rows.
Here's what I have before I add the measure to the visual, with the two slicers selected:
and then I get all the rows (parts) when I add in my measure that shows a 1 for parts with SumNetSold > 0 else 0.
(can't attach the pbix, I'll try and load and link it)
https://drive.google.com/file/d/1mSwTTSFh6AReP07DuhcH93GwlA5OmvsL/view?usp=sharing
Hope this link works
Thank you all for any help
Usually that is done through the data model. Note that RELATED only applies to calculated columns.
2 Replies
- lbendlin
Super User
Usually that is done through the data model. Note that RELATED only applies to calculated columns.
- Ashish_Mathur
Super User
Hi,
I do not know what result you want but does this measure work?
NoDemand = IF ( [SumNetSold] > 0, 1, BLANK() )