Forum Discussion

c_avu's avatar
c_avu
Frequent Visitor
1 year ago

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...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi c_avu ,

 

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. 

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.

 

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.

  • c_avu's avatar
    c_avu
    Frequent Visitor
    1 year ago

    I need both [smcost] [smquant] in columns

    Semantic ModelReportDesired output matrix

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      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.