Bernat Agulló on 03 Feb 2022 10:05:54
There should be a COLUMNNAMESINSCOPE(table) which returns a single column table with the column names of the table which are part of the filter context -- for multigrain fact tables it would ease the DAX I think.
I can have a small calculated table with the names of the attributes related to the smaller grain, and then with this function I could check if there is overlap between the two and thus blank out any measures that read from the larger grain fact table. As it is now I need to do a
IF( ISINSCOPE(tbl[atr1]) || ISINSCOPE(tbl[atr2]) || ... , BLANK(), do calculations)
for wide tables this can be quite painful.
Thank you!