Forum Discussion
SelectedColumns measure
- 9 years ago
It's not possible to dynamically populate the fields based on selection in slicer.
In this scenario, I suggest you create a hierarchy like "Head Office->Area Of Operation". I think this should be the most effective workaround, even you have to go HeadOffice level first, then drill down to detail locations.
Regards,
It's not possible to dynamically populate the fields based on selection in slicer.
In this scenario, I suggest you create a hierarchy like "Head Office->Area Of Operation". I think this should be the most effective workaround, even you have to go HeadOffice level first, then drill down to detail locations.
Regards,
- baronraghu9 years agoHelper III
- v-sihou-msft9 years agoMicrosoft Employee
In your IF statement, it will return a dynamic table context, which is not supported in DAX. Please refer to links below:
Data Analysis Expressions (DAX) Overview
Row Context and Filter Context in DAX
Regards,