Forum Discussion
baronraghu
Helper III
Helper IIISelectedColumns measure
Hi All, I am working on a dashboard and would require your help in a measure. I have slicers for the the name of companies Wallmart Facbook Microsoft Google Apple I have a map whi...
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,
baronraghuHelper III
Helper III
v-sihou-msft
Microsoft Employee
Microsoft 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,