cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors