Forum Discussion
Create New Table with Existing Measure
Hello all.
I have created some measures in my project which I can successfully display in Table-Visual.
However, how can I replicate this visualised table in a new Table?
Basically what the measure does is to countrows based on certain calculations. Thank you
Existing visual
(Table)
Department, Month, Year, Points(measure)
Hi raddy_dee - You can use DAX to create a new calculated table that mirrors the aggregation of your existing table visual. Here's how to approach it:
-
Go to "Modeling" Tab in Power BI Desktop.
-
Click on New Table to create a calculated table.
NewTable =
SUMMARIZE(
ExistingTable,
ExistingTable[Department],
ExistingTable[Month],
ExistingTable[Year],
"Points", [Points_Measure]
)These methods should help you replicate the logic and layout of your existing table visual in a new table format. Hope this helps
-
2 Replies
Hi raddy_dee - You can use DAX to create a new calculated table that mirrors the aggregation of your existing table visual. Here's how to approach it:
-
Go to "Modeling" Tab in Power BI Desktop.
-
Click on New Table to create a calculated table.
NewTable =
SUMMARIZE(
ExistingTable,
ExistingTable[Department],
ExistingTable[Month],
ExistingTable[Year],
"Points", [Points_Measure]
)These methods should help you replicate the logic and layout of your existing table visual in a new table format. Hope this helps
-
Create a new table ( Modelling > New Table)
NewTable =
SUMMARIZECOLUMNS(
OriginalTable[Column1],
OriginalTable[Column2],
"CountRows", [CountRowsMeasure]
)This creates a summarized table with columns from your original table, along with the result of the measure.
If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
