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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.