Microsoft Fabrics multiple Calculation Groups in report

Question

Hello,Kind of new with this fabrics and powerbiI have a usecase I need to group measure into groups. So i'm using calculation groups in semantic model.&nbsp;Calculation Group one:created a measuregroup 'mgcosts'and created 3 measures in it, 'cost eur', 'cost usd', 'cost localcurrency'and a selectedmeasure 'smcost = selectedmeasure()'&nbsp;Calculation Group two:created a measuregroup'mgquant'and created 2 measures in it, 'volume', 'units'.and a selectedmeasure 'smquant = selectedmeasure()'In my report, I used matrix chartRows: I used some titles from dimension tablesColumns: measuregroups --&gt; mgcosts, mgquantvalues: smquant, smcosts&nbsp;and I have two chicklet slicers for both&nbsp;mgcosts, mgquantidea is,if i select a measure 'cost eur' and 'cost usd' in 1st chiclet slicer, 'volume' from secondexpected matrix is like below+----------|---------------------------------+| Product&nbsp; &nbsp;| cost eur | cost usd&nbsp; | volume&nbsp; |+----------|----------------------|----------||Product A |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||Product B |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||Product C |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||Product D |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |+----------|------------------------------+But it is not what i'm getting like i wanted,I'm getting like below+----------------------------------|-----------------------+| mgcosts&nbsp; &nbsp;| cost eur&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| cost usd&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|| Product&nbsp; &nbsp; | smcost&nbsp; | smquant&nbsp; | smcost | smquant&nbsp; &nbsp; &nbsp;| +-----------|----------------------|------------------------||Product A&nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||Product B&nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||Product C&nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||Product D&nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|+-----------|----------------------|-----------------------+can anyone please point me what i'm doing wrong here ?Many Thanks&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;c_avu&nbsp;,
&nbsp;
It seems that your add [cost eur]/[cost usd] in matrix column fields, and add [smcost]/[smquant] in value fields. So your matrix will be expanded.&nbsp;
Your issue is based on data model. I suggest you to share a sample pbix file with us and show us a screenshot with the result you want. It will make it easier for us to find the solution.
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

c_avu · Answer

I need both&nbsp;[smcost] [smquant] in columnsSemantic ModelReportDesired output matrix

anonymous · Answer

Hi&nbsp;c_avu&nbsp;,
&nbsp;
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:&nbsp;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.
&nbsp;
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.
&nbsp;
&nbsp;

Forum Discussion

Microsoft Fabrics multiple Calculation Groups in report

3 Replies

Related content

Microsoft Fabric Prevent multiple pipeline triggers when multiple files arrive simultaneously.

Using Visual Calculation on a Calculated Group with Multiple Calculated Items

CALCULATE with multiple filters

Microsoft Fabric – Event trigger fires multiple times when multiple files arrive

Conditional formatting using multiple calculation groups