cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
airwolf39
Resolver I
Resolver I

Apply a measure to only one field in a matrix?

Hi all, 

 

I need a measure where "Consolidate" and "defer" only shows up at the customer name level and not on the sale order drill down as it is doing currently (highlighted below). I would like the "defers" in the below example to be blank.

 

Capture.PNG 

Any help would be appreciated.

 

Thanks,

Brian

1 ACCEPTED SOLUTION

Try using ISINSCOPE with the Sales Order No column and put your measure in the false condition (blank() if true).

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

3 REPLIES 3
amitchandak
Super User IV
Super User IV

@airwolf39 , isinscope can help

if(isinscope (Table[Customer_name]), [Model recommendation], blank())

 

https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

I have never used isinscope before, but it appears to be working in a way that i would not expect. For some reason the formula shows that my sales order #s are inscope of the customer name and so the forumla doesnt work:

 

Capture.PNG

Try using ISINSCOPE with the Sales Order No column and put your measure in the false condition (blank() if true).

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors