Forum Discussion

rhayward2209's avatar
rhayward2209
Helper I
5 years ago

Incorrect Measure Total with Measure referencing multiple tables

I'm having the common porblem of not having the total on a table visualistion be a sum of the rows above it. I've looked into solutions for it but I can't seem to find a way to apply them to my more ...
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, rhayward2209 

 

It’s my pleasure to answer for you.

According to your description,Have you tried to use the summarize formula, but still can't get the desired result? If yes, please check the results of the measure in the visual to see if there are any errors in data other than total.

I think it might be other issues such as relationship, time inconsistency, etc.Could you please share some sample data on onedrive for business and your desired result?So we can help you soon.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rhayward2209's avatar
rhayward2209
Helper I
5 years ago

Hi v-janeyg-msft ,

 

I would love to share some sample data however the data is sourced from 6-7 different data sets and uses measures so the complexity of providing you that data is quite high.

 

I agree that the issue probably stems from some kind of relationship issue, or the measure its self as the summarise measure still doesnt give the correct respons.

 

Please let me know what you think.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support
    5 years ago

    Hi, rhayward2209 

     

    You can try to make a sample with fake data, which only contains a few rows of data.

    I’m sorry if you don’t provide more relevant information, it’s hard to help you.

     

    Best Regards

    Janey Guo