Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Apr 08, 2025
Solved

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!

SergeiBaklan 

  • 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

  • DavidWilson's avatar
    DavidWilson
    Iron 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.

Resources