topic Re: Two selectedvalue returning blank rows ! in DAX Commands and Tips

Two selectedvalue returning blank rows !

souvik900766 — Tue, 06 Jul 2021 10:43:20 GMT

Hi !

Two selectedvalue returning blank rows !
My measure :-

IF(SELECTEDVALUE(GTC[Company])="ABC" && SELECTEDVALUE('Ctg Sort Table'[Ctgry Nomen])="CCTM (EX-ED)",CALCULATE(ABC TM Share CY],ALL('Ctg Sort Table'),
but
if I write the same measure removing the first selectedvalue then no is coming.
Any Clue !

Thanks in advance !

Re: Two selectedvalue returning blank rows !

amitchandak — Tue, 06 Jul 2021 15:37:34 GMT

souvik900766 ,

Try this or

IF(CountX(allselected(GTC[Company]), GTC[Company] in {"ABC" ,"CCTM (EX-ED)" }) +0 >=1 ,CALCULATE(ABC TM Share CY],ALL('Ctg Sort Table'))

IF(CountX(allselected(GTC[Company]), GTC[Company] in {"ABC" ,"CCTM (EX-ED)" }) +0 >=2 ,CALCULATE(ABC TM Share CY],ALL('Ctg Sort Table'))