The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi there,
I have use Table Visual in Power BI. Can anyone help me to get the Total value of Earned Cost when isterminal is true
The other rows should be calculating and showing
I tried this
Solved! Go to Solution.
Hi @ashmitp869 - Create a new measure will calculate the sum based on whether it is in the row context (for individual rows) or in the total context.
you want to calculate the sum of CBEarnedTotalCostToDate for the rows where Is_terminal is True only for the total row, while showing all rows in the table visual.
Earned Cost =
IF(
ISINSCOPE(Projects[Project ID]),
SUM(CurrentBudget[CBEarnedTotalCostToDate]),
CALCULATE(SUM(CurrentBudget[CBEarnedTotalCostToDate]), CostItem[Is_terminal] = TRUE)
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |
Hi @ashmitp869 - Create a new measure will calculate the sum based on whether it is in the row context (for individual rows) or in the total context.
you want to calculate the sum of CBEarnedTotalCostToDate for the rows where Is_terminal is True only for the total row, while showing all rows in the table visual.
Earned Cost =
IF(
ISINSCOPE(Projects[Project ID]),
SUM(CurrentBudget[CBEarnedTotalCostToDate]),
CALCULATE(SUM(CurrentBudget[CBEarnedTotalCostToDate]), CostItem[Is_terminal] = TRUE)
)
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
Proud to be a Super User! | |