Create New Table with Existing Measure

[raddy_dee]

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)

[Kedar_Pande]

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

[rajendraongole1 · Accepted solution]

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:

1. Go to "Modeling" Tab in Power BI Desktop.

2. 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