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,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you lbendlin for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the issue is resolved? If not please provide some sample data that covers your issue so that we can look more into it and provide you the best solution possible. Let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

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