Forum Discussion
Dynamically create measure based table
Anonymous you can create a table using summarize function and then use UNION to append these tables together, something like dax expression given below
Table6 = UNION ( SUMMARIZE ( Table1, Table1[Id], "Name", "Table1", "Tasks", [Task Measure], "Travelers", [Traveles Measure] ), SUMMARIZE ( Table2, Table2[Id], "Name", "Table2", "Tasks", [Task Measure], "Travelers", [Traveles Measure] ), SUMMARIZE ( Table3, Table3[Id], "Name", "Table3", "Tasks", [Task Measure], "Travelers", [Traveles Measure] ) )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Anonymous solution attached, the similar thing you can do in power query instead of Dax
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Hi parry2k , Ashish_Mathur
https://drive.google.com/file/d/1IW3idw1azJ2-1wf2Z-HXy610hKlsmorX/view?usp=sharing
I created dummy data which replicates my requirement in this PBIX file attached.
So, this PBIX file has 5 tables- each has 2 columns- Tasks and Travelers. The values in any of the tables do not relate to the value in another table.
In Excel- my data would look like below- Tasks as Count & Travelers as Distinct Count
| Table1 | Table2 | Table3 | Table4 | Table5 | |
| TASKS (COUNT) | 100 | 20 | 30 | 40 | 50 |
| TRAVELERS (DISTINCT COUNT) | 50 | 10 | 15 | 20 | 25 |
I want to create a visual out of these 5 tables as below:-
Anonymous solution attached, the similar thing you can do in power query instead of Dax
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡