Forum Discussion
Grgouping groups
I need to group groups and calculate only last group values to not dublicate each parents total sums, as each parent group have total sum of their child. for exmpla group 1 have total of 11+12+16, 11 total of 113+114 and etc
Hi Analitika ,
Sorry for that we cannot use the Power Query Editor in your PBIX.
So we create a sample, and you can refer the following steps to create the hierarchy.
1. Merge the current table.
2. Expand the sas_kod column.
3. Then merge the current table again.
4. Expand the change type sas_kod.
5. Add two columns.
6. At last we can create a matrix table using this table.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
3 Replies
Hi Analitika ,
Sorry for that we cannot use the Power Query Editor in your PBIX.
So we create a sample, and you can refer the following steps to create the hierarchy.
1. Merge the current table.
2. Expand the sas_kod column.
3. Then merge the current table again.
4. Expand the change type sas_kod.
5. Add two columns.
6. At last we can create a matrix table using this table.
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Analitika , refer if this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
No, it is grouping only one level i need all posible levels
