Forum Discussion
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 in group by table is static
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.
3 Replies
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
Hi Anonymous
thanks for the reply, consider I have queried the left table from db, that is filtering by some slicer on the date, I need to create a dynamic group by table from main table which is filtering as well by slicer as shown in the right
Thanks for your time and consideration🙂
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.
