Forum Discussion
DAX - How to check user segment filter selection ?
Community Supporthi, Anonymous
This involves the row context in DAX calculation.
https://www.sqlbi.com/articles/row-context-and-filter-context-in-dax/
For your case, just try this:
If COUNTRY table is dim table, use [COUNTRY] field from data table in a gird, do not use [COUNTRY] field from COUNTRY table.
If COUNTRY table is not dim table, create a dim table, then create a relationship with Country table and use [COUNTRY] field from dim table in a gird.
Here is a simple pbix file, please try it.
Best Regards,
Lin
COUNTRY is indeed a dim table but [COUNTRY] is not the key. It's a different hierarchy from the key that is linked to my data table. Therefore I cannot display the field from my data table.
- v-lili6-msft
hi, Anonymous
Could you share a simple sample pbix file with your expected output?
Best Regards,
Lin