Forum Discussion

Johnsie's avatar
Johnsie
Frequent Visitor
2 years ago
Solved

Create tables using measures

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.

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies