Forum Discussion
Visualizing data from different fact tables with different granularity in the same list visual
i would suggest to use a matrix .
then in your measure you can use the isinscope function to control the calculation per each level .
NB : when using isinscope , always start with the lowest level to the highst . example below :
matrix : product category --> product
measure =
switch(true() ,
isinscope(tbl_name[prodcut]) , calculation_1 ,
isinscope ( tbl_name[product category) , calculation_2
)in your example, you can set, that if isinscope( dim_manufacturer[name] , to return blank() --> for budget .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠
i would suggest to use a matrix .
then in your measure you can use the isinscope function to control the calculation per each level .
NB : when using isinscope , always start with the lowest level to the highst . example below :
matrix : product category --> product
measure =
switch(true() ,
isinscope(tbl_name[prodcut]) , calculation_1 ,
isinscope ( tbl_name[product category) , calculation_2
)
in your example, you can set, that if isinscope( dim_manufacturer[name] , to return blank() --> for budget .
let me know if this helps .
If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠