The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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?
Hi,
Share the download link of the PBI file.
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
@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 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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
80 | |
78 | |
43 | |
37 |
User | Count |
---|---|
157 | |
112 | |
64 | |
60 | |
54 |