Forum Discussion

souvik900766's avatar
souvik900766
Icon for Helper IV rankHelper IV
5 years ago
Solved

Two selectedvalue returning blank rows !

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('C...
  • amitchandak's avatar
    amitchandak
    5 years ago

    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'))

     

    or

     

     

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

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'))

 

or

 

 

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