Forum Discussion
Table visual is not filtered due to dax measure
Hi Team,
I have a visual as below:
when i filter company as below:
Table should give me records for selected company and not any other records. But the table here shows all records which means the filter is not recognized. for example, the site and device slicer shows correct records for filtered company but table is not:
I guess the problem is due to the below dax online status:
This brings in all records irrespective of the selected slicer.
Could you please help me resolve this?
Please advise!
PFA file here https://1drv.ms/u/c/cfada767f73d87ed/EXQ1kQXsFBJHlZ9f4j-I7SoBIfConcyHbrD6SHhnuDaX_Q?e=VzxQkY
Thanks in advance!
DAX measures rely on context—row context from tables and filter context from filters applied in the report. Check if your measure is calculating correctly based on the context it's supposed to receive.
1 Reply
- DavidWilsonIron Contributor
DAX measures rely on context—row context from tables and filter context from filters applied in the report. Check if your measure is calculating correctly based on the context it's supposed to receive.