Forum Discussion

laciodrom_80's avatar
laciodrom_80
Helper IV
9 years ago

Filtering table by measures

Hi,   I'm able to create a new table filtering like this:   NewTable = FILTER(Table; Table[Area]<= 500 && Table[Area] >= 10 I'm not able but would it be possible to use measures instead of stati...
Tutorial Requests
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

laciodrom_80

 

If your measure 1 and measure 2 can be sliced on row level, your formula should work. See my sample below:

 

 

Then you can create a calculated table with similar expression.

 

 

Regards,