Forum Discussion

Swiya's avatar
Swiya
Frequent Visitor
1 year ago
Solved

Totals in Matrix visual showing wrong total

I have a measure that calculates the cost of each employee per month by dividing the total cost by the number of month they are available for this year. Following is the measure: var capacity = CA...
Need Help
  • Swiya's avatar
    Swiya
    1 year ago

    Hi v-achippa, 

    This is resolved but I didnt get much help on the same topic

    What I discovered was that the sumx doesnt work in the same measure where you calculate the it. I created another measure and calculated sumx there and the totals came out to be correct.

    Let me know if i mark this as resolved

v-achippa's avatar
v-achippa
Community Support
1 year ago

Hi @Swiya,

 

We wanted to kindly follow up to check if the issue is resolved? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

Swiya's avatar
Swiya
Frequent Visitor
1 year ago

Hi v-achippa, 

This is resolved but I didnt get much help on the same topic

What I discovered was that the sumx doesnt work in the same measure where you calculate the it. I created another measure and calculated sumx there and the totals came out to be correct.

Let me know if i mark this as resolved

  • v-achippa's avatar
    v-achippa
    Community Support
    1 year ago

    Hi Swiya,

     

    Thank you for the response and confirming that the issue is resolved. If possible could you please provide the measure/solution and accept it as a solution so that other community members will find it more easily. If not, please accept the above post as a solution. 

     

    Thanks and regards,

    Anjan Kumar Chippa

    • v-achippa's avatar
      v-achippa
      Community Support
      1 year ago

      Hi Swiya,

       

      As we haven’t heard back from you, we are closing this thread for now. If you have any further issue, please raise a new thread in the community forum, we are ready to assist you on it.

      Thank you for being part of Microsoft Fabric Community.

       

      Thanks and regards,

      Anjan Kumar Chippa