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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.