FILTER a table using a value calculated by a measure

marisasoares — Wed, 01 Nov 2023 01:00:45 GMT

Hello.

So I calculated a measure (and even a column) and when I represent it on a card or table the value is the one I want, so I don't think something is wrong with that measure. However I want to filter a table based on that value.
Example:

Id	Value
1	299
2	299
3	299
4	300
5	300
6	300

If the measure value is 300, I want a table that contains only the ids 4, 5 and 6.

For that I created a new table and wrote this DAX formula:

Table = FILTER('TableB', 'TableB'[Value] = [Measure])

But the table is empty. However when I type

Table = FILTER('TableB', 'TableB'[Value] = 300)

the table is not empty and it's correct.

When I represent that Measure on a table, I get this (for example):

Measure

300

The measure is created on a different tableA.

Could someone help me please? Thank you 🙂

Re: FILTER a table using a value calculated by a measure

FreemanZ — Wed, 01 Nov 2023 01:18:42 GMT

the real value of a measure depends on its context. the context is different in a card visual and a calculated table.

topic Re: FILTER a table using a value calculated by a measure in DAX Commands and Tips

FILTER a table using a value calculated by a measure

Re: FILTER a table using a value calculated by a measure