Forum Discussion
Solved
Create another table with group by from Existing table
Hi, I need to create a dynamic group by table from existing table that is filtering with the slicer, everything I used inclyding summarize table didn't work as slicer can't filter this and the data i...
Hi saeidspr
Because your name field is filtered by the slicer, so you just need to create two measures.
cnt = COUNTA ( table[id] )sumAmount = SUM ( table[Amount] )then put the name field and the teo measures to the visual.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi saeidspr
You can use measure, measure can change dynamically by the slicer. and you want to create group, what is the group like? Can you provide some sample data and the output you want so that can provide more suggestion for you.
Best Regards!
Yolo Zhu