how to use a measure in a column

[Anonymous]

Hello everyone
I have a new measure that calculates variables. But I need that these variables can be used to filter other columns.

For example:
measure 1 =
    VAR  VAR1 = expression...
    VAR  VAR2 = expression...

      RETURN VAR1 (VAR1 has for this example the value of 23, so VAR1 = 23)

Table 1
column 1
10
20
23
30

32
...
So I need somehow that VAR 1 can filter column 1 of table 1 choosing 23

For another example, the value of VAR can change for example to 10 and I must do the same exercise (in column 1 choosing 10)

Any ideas?
I thank you very much!

[Anonymous]

Thanks @amitchandak . This is what I have:

Column Torres is my VAR1 (from a measure)  and the other column is a comun for a other table (Column1 table1) In the blue circule is the return of VAR1 =13,1. I want the other column to be filtered with that value.

[Anonymous]

Hi @Anonymous ,

Do you want to use measure to filter field values in table? If yes, please review the following threads which have similar requirement. Hope they can help resolve your problem.

Filtering Table Based On Measure Value

Filter by a measure

Filter with calculated measures

Applying a measure filter in Power BI

Best Regards
Community Support Team _ Rena Ruan
If this post helps, then please consider Accept it as the solution to help the other members find it more.

[amitchandak]

@Anonymous ,

You need some grouping for that

return

sumx(filter(summarize(Table, Table[Group1], "_1", Sum(Table[Column1])),[_1] > Var1 ),[_1])