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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
souvik900766
Helper IV
Helper IV

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

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 !
2 REPLIES 2
Fowmy
Super User
Super User

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


Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Hi This is my working template .
Capture.PNG
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 !
 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors