Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I am quite new to Power BI and I have the following issue. I have the following visual, where the column "Check_Global" is actually a measure.
The measure is computed as follows.
As you can see, ID totals are corrected but month totals no!
Please not that this calculation is very complex, so the ID sum could be not equal to the monthly sum...however it is useful to have a graphical representation of the monthly data. Instead, the sum over all ID for each month should be the exact sum!
The measure is computed as follows.
I humbly ask your help!
Thanks
Andrea
Solved! Go to Solution.
Hi,
I am not sure how your semantic model looks like, but please try something like below whether it works.
Check_Global =
SUMX (
VALUES ( calendar_table[date_column] ),
CALCULATE (
IF (
OR (
SUMX ( 'CHP Units', 'CHP Units'[Check_Hours] ) > 0,
SUMX ( 'CHP Units', 'CHP Units'[Check_EE] ) > 0
),
1,
BLANK ()
)
)
)
Hi,
I am not sure how your semantic model looks like, but please try something like below whether it works.
Check_Global =
SUMX (
VALUES ( calendar_table[date_column] ),
CALCULATE (
IF (
OR (
SUMX ( 'CHP Units', 'CHP Units'[Check_Hours] ) > 0,
SUMX ( 'CHP Units', 'CHP Units'[Check_EE] ) > 0
),
1,
BLANK ()
)
)
)
Hi, it worked perfectly. Thank you
Hello @AndreaBracco
Could you please provide sample data that fully represents your issue or question in a usable format, rather than a screenshot? Ensure the dataset is anonymized and does not contain any sensitive or unrelated information.
Additionally, it would be very helpful if you could share the expected outcome based on the provided data - this can be in any format, including a screenshot. Having a clear reference for comparison will significantly improve the chances of getting the correct solution in the first response.
For best practices, you may find the following links useful:
Thanks,
Udit
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Proud to be a Super User
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |