Forum Discussion
Solved
How to Combine Data from Tables with Different Granularity Levels for a Visual
Not sure if what I need is possible but I'd like to use data from multiple tables with different levels of granularity in a visual. Right now the tables are joined at the sub-category level but one t...
what you want to do is possible using dax . function isinscope if you are using a matrix,
example of the synthax :
measure =
switch(
true() ,
isinscope ( region) , balnk() ,
isinscope ( area ) , [Overhead for each Area calculation ]
let me know if it works for you .
If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I would appreciate hitting that kudos button 👍🤠
Wanted to come back to this thread with the solution I found for those with the same issue. Big thanks to Daniel29195 for mentioning the ISINSCOPE function as that is what ultimately worked. Here is the measure that worked and left no data in the Region rows for overhead.
Overhead = if(ISINSCOPE('Df-dim-Region'[Region]),BLANK(), sum('Df-Overhead'[Overhead Amount])).