Create tables using measures

[Johnsie]

Hello,

I created some calculated tables using SUMMARIZE() but these created tables are not able to be filtered by other tables when used in a visual.

Is there a way to create calculated tables using measures so that the data is able to be filtered by the tables from which it was calculated or is there another way to do it?

For example, I want to calculate the sales of open projects per year and month in another table to show it in a visual and to be able to filter it by the columns Business Unit or Country in the table Projects. I know I could show this in a visual using the table Projects but this is only used as an example.

Sales of Projects (Open) =

SUMMARIZE (

    'Projects',

    'Projects'[Created On].[Year],

    'Projects'[Created On].[Month],

    "Full Production",

        CALCULATE (

            SUM ( 'Projects'[Sales] ),

            CONTAINSSTRING ( 'Projects'[Status ], "Open" )

        )

)

Thanks for your help.

[v-tianyich-msft · Accepted solution]

Hi @Johnsie ,

Calculated tables can't be filtered, you can create relationships and then show the effect you want by new parameter, like this:

relationship:

Please feel free to correct me and provide more information if I have misunderstood you!

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

All the secrets of SUMMARIZE - SQLBI

Best practices using SUMMARIZE and ADDCOLUMNS - SQLBI

In short, use SUMMARIZECOLUMNS and add the "Full Production"  column in a later step.