Issue with a matrix visual.
Business requirement :
Show budget per region, but total needs to include an adjustment.
I do not want to show the adjustement as a line (because no other data is attached) but just in the total.
|Total (A + B + (non region adjustement))||125||130|
Thank you !
I can't figure it out
Solved! Go to Solution.
Hi @qmartiny ,
You could use ISINSCOPE() to custom your total row.
IF(ISINSCOPE('Table'[Region]),normal data,total data)
Doing exactly that it seems
Global comped refers to a different table than the Budget one but I tried with the key from the budget table as well with no luck.
Thank you for your help !!
Is this field "Global_comped[Global_comped]" the field you are using in your visual? (the field in your visual needs to be the same as the one in the ISINSCOPE function)
yes that's correct.
And theres a 1-1 relationship between my 'global comped' table (condensed region names) and the region names in the budget table
You probably need to create a measure and then use the technique here:
Quick Measure, Measure Totals, The Final Word should get you what you need:
You have to try like
measure =if(ISFILTERED('Table'[Region]) ,sum(Table[Value]),sum(Table[Value])+25) OR measure =if(ISFILTERED('Table'[Region]) ,sum(Table[Value]),sum(Table[unadjusted Value]))
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Mark your calendars and join us for our next Power BI Dev Camp!