topic Re: Return value in a row with different filter in measure and row in DAX Commands and Tips

Return value in a row with different filter in measure and row

souvik900766 — Sun, 04 Jul 2021 16:07:39 GMT

Hi !

I want to return a measure value in a row which doesnot match with the measure context.

My Case :-

I have a row with a category name called ABC TM where i want to return a value and the measure for that formula is

DEF TM Share = CALCULATE([CY],'Ctg Sort Table'[Ctgry Nomen]="DEF TM").
I want to do it to compare the DEF TM value against ABC TM s value.
But it is showing blank against ABC TM.
I used the measure

IF (

SELECTEDVALUE(Ctg Sort Table'[Ctgry Nomen]="ABC TM",

CALCULATE( [DEF TM Share ],ALL('Ctg Sort Table'))

How can I return the value of DEF TM in ABC TM row..
Thanks in advance !

Re: Return value in a row with different filter in measure and row

Fowmy — Sun, 04 Jul 2021 19:45:35 GMT

souvik900766
If you could share some sample data and the expected result, it would be great.

Re: Return value in a row with different filter in measure and row

souvik900766 — Mon, 05 Jul 2021 06:20:38 GMT

Hi This is my working template .

I want to show the DEF TM Value against ABC TM under Competitor Share Measure but currently it is showing blank.
Measure I have used:-

IF (

SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="ABC TM",[DEF TM])

Thanks in advance !