topic Re: IF to return the value of different columns. in DAX Commands and Tips

IF to return the value of different columns.

Anonymous — Tue, 07 Jul 2020 14:38:46 GMT

I have two columns with different values.

I have the column "CONAMA" and "COPAM" with specific values

I would like to create a custom column, which I would use as a filter, which if I select CONAMA will return the value of the CONAMA column and if I change it to COPAM it shows me only the values of the COPAM column, is it possible?

Example: CONAMA | COPAM | COLUMN FILTER

10 | 5 | (This column will change between the value 5 or 10, according to the graph filter, CONAMA or COPAM)

Re: IF to return the value of different columns.

Greg_Deckler — Tue, 07 Jul 2020 15:00:56 GMT

Anonymous - You would have to use a measure for that, columns are not dynamic.

Re: IF to return the value of different columns.

Anonymous — Tue, 07 Jul 2020 15:11:18 GMT

Sorry but I can't reference the column with a measurement

How could you create a filter to meet this need? if it is Conama, pull one column and if it is Copam it will return me another column.