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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Frequent Visitor

## Measure giving different value from table total

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
Super User

Hi,

Share the download link of the PBI file.

Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
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

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.

Frequent Visitor

Table 1:

 JOB CODE PLANNED HRS START DATE END DATE 1 35 20/01/2023 31/01/2023 2 35 21/01/2023 31/01/2023 3 35 21/01/2023 31/01/2023 4 35 25/01/2023 31/01/2023

Table 2:

 JOB CODE SECTION ACTUAL HRS STOP DATE 1 A 4 22/01/2023 1 A 6 23/01/2023 1 B 10 23/01/2023 1 B 11 24/01/2023 2 A 2 22/01/2023 2 A 5 23/01/2023 2 B 9 23/01/2023 2 B 13 24/01/2023 3 A 3 22/01/2023 3 A 6 23/01/2023 3 B 12 23/01/2023 3 B 11 24/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:

## Helpful resources

Announcements

#### 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 Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

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

Top Solution Authors
Top Kudoed Authors