Forum Discussion
How to Combine Data from Tables with Different Granularity Levels for a Visual
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 👍🤠
Community Champion
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 👍🤠
I'm not quite sure how your formula works. Here are my tables:
Df-Area Stats
| Area | Overhead |
Df-Region Stats
| Region | Area | Sales | Expenses |
Then I have two dimension tables
Df-dim-Area
| Area |
Df-dim-Region
| Region |
So would your formula look like this?
isinscope('Df-dim-Region'[Region]), blank(),
Or maybe add a [Region] column to my 'Df-Area Stats' table (with just blank values) and join that to my dimension table?