Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Incorrect Totals

Hello,

The data in my table is correct.  But, the totals is not matching up, or not showing at all.

Pretty sure it has to do with the relationship.  But when I change it, the data in my table changes and becomes incorrect.

The data in the table is filtered down to a specific version, but I beleive the totals is summing all the versions.

Here is a view of the table:

cbrickman_0-1670953543211.png

The totals should be: 9,565 | 12,127 | 21,692

 

Also, here is view of the relationship between the tables.

cbrickman_2-1670953886420.png

cbrickman_1-1670953861811.png

 

8 REPLIES 8
Greg_Deckler
Super User
Super User

@Anonymous Just chiming in to hopefully get some votes for this idea:

First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Hi, Thanks for the response.

They are measures, created through other measures in the Projectionfinal table.

I had a similar issue lately, you could try this and see if it works, alot of times a SUMX statement with a nested SUMMARIZE as the table, and calling the measure needed in the 4th argument of SUMMARIZE does the trick, Let me know if that works!

Test =
VAR yourmeasure = SUM(your_column)
RETURN
SUMX(
    SUMMARIZE(
        'Your Table',
        'Your Table'[Column1],
        "Calculated",
        yourmeasure
    ),[Calculated]
)
Anonymous
Not applicable

I gave it a try, but ended up with the same data in the table and the same overstated total as before.

I am wondering if I need to address the issue of why there is no total for the Dig Next Week Net at all?

As, it is a part of the Dig Stops calculation.  The first three data column's data and totals are correct.  The next column's data is correct, but no total.  The last column's data is correct, but total is overstated and the same total as the 4th column's.

cbrickman_0-1670960578600.png

The date field is from a seperate table, dimdate.

These are the measure, all created in the Projectionfinal table, in case it helps.

 

cbrickman_1-1670960835656.png

cbrickman_2-1670960917032.png

cbrickman_3-1670960964741.png

cbrickman_4-1670960995388.png

cbrickman_5-1670961066507.png

 

 

 

 

 

 

 

 

I will attempt to replicate those measures in a local dataset I have and see if I can find what the issue is, in the meantime I took a second look at your relationships and realized that you have a bidirectional mant to many  between DimDate and UploadAquisitionPlan, is there a specific reason you chose this? That could be causing issues as well.

 

Keegan_Patton_0-1671023423693.png

 

Anonymous
Not applicable

Hi,

No specific reason on the relationship.  I tried changing it so that just the dimdate filters the UploadAP table and vice-a-versa.  But, no change in the totals or data.

Thanks again for looking into it and the help.

Keegan_Patton
Advocate I
Advocate I

Hello @Anonymous are the columns 'Dig Stops', 'Print Stops', and 'Total Stops' columns or measures?

Anonymous
Not applicable

Morning,

All three are measures.  Was just cosidering if I need to make them Columns?

 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.