Forum Discussion
Microsoft Fabrics multiple Calculation Groups in report
Hello, Kind of new with this fabrics and powerbi I have a usecase I need to group measure into groups. So i'm using calculation groups in semantic model. Calculation Group one: created a mea...
I need both [smcost] [smquant] in columns
Semantic ModelReportDesired output matrix
Hi c_avu ,
According to your statement, I think you add these two parameters in column fields as hierarchy level.
So when you drill down it will show as below.
Did you use field parameter in Power BI to create the calculation group?
For reference: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn
I think you can combine the group as one and then try again.
If this reply still couldn't help you solve your issue, please share a sample file with us.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.