Forum Discussion
Johnsie
2 years agoFrequent Visitor
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 u...
- Anonymous2 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 ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
2 years agoSuper User
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.