Forum Discussion

saeidspr's avatar
saeidspr
New Member
2 years ago
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...
General Comment
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

saeidspr's avatar
saeidspr
New Member
2 years ago

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's avatar
    Anonymous
    Not applicable
    2 years ago

    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.