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

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.