Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
I'm having measures table and i want to consolidate all the measures into column in a table like below screenshot.
Kindly any one help me in this situation.
Solved! Go to Solution.
Hi @Murali777 ,
You might consider using the SUMMARIZE function to create a new table containing the measures, but this new table cannot change dynamically with user selections on the report.
Not like measures, calculate columns/tables(like your myMeasureTable) are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report(like a Slicer).
Create calculated table.
Table 2 = SUMMARIZE('Table',"Measure",[Measure],"Measure 2",[Measure 2])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Murali777 ,
You might consider using the SUMMARIZE function to create a new table containing the measures, but this new table cannot change dynamically with user selections on the report.
Not like measures, calculate columns/tables(like your myMeasureTable) are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report(like a Slicer).
Create calculated table.
Table 2 = SUMMARIZE('Table',"Measure",[Measure],"Measure 2",[Measure 2])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you Liu Yang.
HI @Murali777 ,
To achieve this follow below steps:-
1. Create a table with single column from enter data like below:-
2. Now Move your measures to newly created table from home table or from model view or directly create a new measure inside the new measure table.
3. Now hide or delete the column from new table and then save it:-
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hi Samarath,
Thanks for your time. But the question is, i'm already having the group of measures and i need to form a table with the existing Measures.
e.g) Col1=Measure1, Col2 = Measure 2, Col3= Measure 3.
Like wise i need to form a table by using the existing measure value.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
109 | |
108 | |
93 | |
61 |
User | Count |
---|---|
171 | |
139 | |
133 | |
102 | |
86 |