Forum Discussion
joshua1990
Post Prodigy
Post ProdigyShow available columns based on selection
Hi community!
I have a simple data model with 3 tables:
tblArticle
Article
Price
Size
A
50
40
B
60
50
This table shows me attributes for each article.
...
Hi joshua1990 - I would suggest using Power Query to modify the data model to achieve this result in a matrix:
The key is create the following table which is combination of tables 2 and 3:
note the "N/A" are added using the SELECTVALUE function. This replaces blanks, but it would also replace Duplicates, so be careful with duplicated status.
Also make sure that tblArticles includes all the Articles.
Many thanks
Daryl
Roache's Maxim - transform data as far upstream as possible, and downstream only when necessary. Hopefully the transformation will fold to your data source. With the approach the DAX is much simpler.