Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
souvik900766
Helper IV
Helper IV

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('Ctg Sort Table'),
but 
if I write the same measure removing the first selectedvalue then no is coming.
Any Clue !

Thanks in advance !
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.