Forum Discussion

teja503's avatar
teja503
New Member
2 years ago

Referencing a Field Parameters in AllExcept

Hi Folks,   I need your help in referencing a column selected in Filed parameter dynamically in Allexcept to form a grouping along with other static columns, all from a single Table.   I have thr...
Need Help
teja503's avatar
teja503
New Member
2 years ago

OwenAuger  Thank you very much for your detailed explanation

 

Problem I face here is that I have a huge table with around 100 columns and 16 of them are used in the level slicers. Those columns are combination of calculated columns and groupings. To unpivot such a large table with DAX seems to be practically impossible.

 

Am I missing anything here, help is highly appreciated

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

Ah I see 🙂

If there are calculated columns used in the level slicers, then you are forced to unpivot with a calculated table rather than Power Query.

 

It's not impossible, but a bit tedious to write the code (you could generate it somehow), and the specific columns required would need to be hard-coded.

 

You can limit the Attributes to just the 16 columns though.

 

Here's an example using the Customer table from Contoso Light on dax.do.

https://dax.do/pYc6P1cRhPMjFc/

 

I can't see any other way around doing something like this, as DAX has no way to construct a dynamic column reference 😞