Forum Discussion
Trouble creating calculated & dynamic fields based on single selection
What I'm trying to do is supply a group of hospitals in a slicer where the user must select only one. From there, I want to create a calculated field that takes a few stats from the selected hospital...
You should break this problem into parts. Start by just trying to correctly calculate the stats for the one selected hospital. You click on the slicer and the data table will then be filtered to only show data for that one hospital. You can then write a measure that calculates the stats for that one hospital without writing complex "isfiltered" formulas - this is not required. The slicer provides the filter, so you just write the measure.
Can you do this first and post your progress back here?