Summarize table dynamically based on field parameter

Hi as1195 

Does Manufacturer > Brand > SubBrand > Variant form a "natural hierarchy"? It appears so from your sample data at least 🙂

That is, does any value at a particular level imply a unique value at the level immediately above?

i.e. each Variant exists under a unique SubBrand, each SubBrand exists under a unique Brand etc?

If it is a natural hierarchy, I believe it is possible and I can put together an example. If it is not a natural hierarchy, you could still adjust the model to create a natural hierarchy behind the scenes.

Regardless, I will put together an example based on what I am thinking and reply soon. The main difficulty is that field parameters are intended to determine fields included in a visual, but not to generate dynamic DAX expressions using those fields.