Forum Discussion
Solved
Measure incorporating slicer value
I'm attaching a PBIX file and hoping someone might be able to assist. I've created two separate measures: Avg Encounters/Day Discipline and Avg Encounters/Day Provider. The calculation for both me...
I spent some more time working on the DAX and was able to adjust the part in the denominator that wasn't calculating correctly, and now it's working as expected.
ahiemstra You'll likely need to have slicers that are disconnected from your visual/data table. Then you can simply use MAX or SELECTEDVALUE to grab the desired value and then you can incorporate that into your measure.
Greg_Deckler can you help me understand why I need disconnected slicers? I'm not familiar with these, I've only ever created slicers that are directly tied to my data table. I'm not sure I would know how to go about creating disconnected slicers and then incorporating them into the measures.