Forum Discussion

Jkpeter_629's avatar
Jkpeter_629
Regular Visitor
3 years ago
Solved

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

  • Usually that is done through the data model.  Note that RELATED only applies to calculated columns.

  • Hi,

    I do not know what result you want but does this measure work?

    NoDemand = IF ( 
        [SumNetSold] > 0, 
        1,
        BLANK() 
    )