Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
My 'Recognized' column above is calculating the wrong total at the bottom. How do I fix this?
This column is a new measure, using the following DAX:
Solved! Go to Solution.
Hi @geleigh ,
Because of Row context is most easily thought of as the current row. It applies whenever a formula has a function that applies filters to identify a single row in a table. The function will inherently apply a row context for each row of the table over which it is filtering. This type of row context most often applies to measures.
For more information, you can refer these documentations:
Learn DAX basics in Power BI Desktop - Power BI | Microsoft Learn
Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn
Measures in Power BI Desktop - Power BI | Microsoft Learn
You can add a measure like this:
R =
IF (
COUNTROWS ( VALUES ( Projects_Task_Workplans[ID] ) ) = 1,
[Recognized],
SUMX (
VALUES ( Projects_Task_Workplans[ID] ),
'Projects_Task_Workplans'[Recognized]
)
)
The result is:
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @geleigh ,
Because of Row context is most easily thought of as the current row. It applies whenever a formula has a function that applies filters to identify a single row in a table. The function will inherently apply a row context for each row of the table over which it is filtering. This type of row context most often applies to measures.
For more information, you can refer these documentations:
Learn DAX basics in Power BI Desktop - Power BI | Microsoft Learn
Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn
Measures in Power BI Desktop - Power BI | Microsoft Learn
You can add a measure like this:
R =
IF (
COUNTROWS ( VALUES ( Projects_Task_Workplans[ID] ) ) = 1,
[Recognized],
SUMX (
VALUES ( Projects_Task_Workplans[ID] ),
'Projects_Task_Workplans'[Recognized]
)
)
The result is:
Hope this helps you.
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please see this video for how to fix that - (2) Power BI - Tales from the front #01 - Getting the Right Total - YouTube
Pat
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
55 | |
55 | |
37 | |
30 |
User | Count |
---|---|
78 | |
64 | |
45 | |
43 | |
40 |