Create another table with group by from Existing table

[saeidspr]

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

[saeidspr]

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🙂

[Anonymous · Accepted solution]

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.

[Anonymous]

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