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
IssieWissie
Frequent Visitor

Measure giving different value from table total

 

IssieWissie_2-1675128256921.png

As annotated by the arrows, I have a measure that totals to different amounts in a card and a table. The table figure is correct. The exact same filters are applied to both(I copied the table and turned it into a card). Why might this be and how can it be solved?

4 REPLIES 4
Ashish_Mathur
Super User
Super User

Hi,

Share the download link of the PBI file.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
HotChilli
Super User
Super User

It's a measure totals issue and it's by design.  Search for 'dax measure totals' and have a go at fixing it.

Post back with your measure, model and some data if you can't work it out

amitchandak
Super User
Super User

@IssieWissie , That is strange. Please share the measure calculation.

 

Make sure no row is selected/clicked in the table and there is no visual level filter

 

 

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Table 1:

JOB CODEPLANNED HRSSTART DATEEND DATE
13520/01/202331/01/2023
23521/01/202331/01/2023
33521/01/202331/01/2023
43525/01/202331/01/2023

Table 2:

JOB CODESECTIONACTUAL HRSSTOP DATE
1A422/01/2023
1A623/01/2023
1B1023/01/2023
1B1124/01/2023
2A222/01/2023
2A523/01/2023
2B923/01/2023
2B1324/01/2023
3A322/01/2023
3A623/01/2023
3B1223/01/2023
3B1124/01/2023

 

I have put together a sample which is similar to what I'm using. The data is coming from a direct query (table 2) and excel sharepoint (table 1). Measure 4 is only a sum of all different sections for a job. So for Job 1, Measure 4 is 31.

 

Since table 1 is a sort of unique job code table, I've related table 1 and 2 through "JOB CODE". Then I've related table 1 by connecting "END DATE" with my calendar table. My reasoning was that due to the nature of table 2 having different dates allocated to a job code, relating the table 1 instead which has a single date allocated instead to "group" all data to a single date. Lastly the filters I have on the actual visuals are the following:

IssieWissie_0-1675198673848.png

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 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.

Top Solution Authors