Forum Discussion
EaglesTony
1 year agoPost Prodigy
Need help in collapsing table on itself
Hi, I have the following table: FeatureKey AddedOrRemovedTotal Count ABC RemovedFromParent 12 ABC AddedToParent ...
- 1 year ago
Try this calculated table:
NewTable = ADDCOLUMNS ( VALUES ( BaseTable[FeatureKey] ), "TotalRemoved", CALCULATE ( SUM ( BaseTable[Count] ), BaseTable[AddedOrRemovedTotal] = "RemovedFromParent" ), "TotalAdded", CALCULATE ( SUM ( BaseTable[Count] ), BaseTable[AddedOrRemovedTotal] = "AddedToParent" ) )Add "+ 0" if you want 0 instead of blank:
NewTableWithZero = ADDCOLUMNS ( VALUES ( BaseTable[FeatureKey] ), "TotalRemoved", CALCULATE ( SUM ( BaseTable[Count] ), BaseTable[AddedOrRemovedTotal] = "RemovedFromParent" ) + 0, "TotalAdded", CALCULATE ( SUM ( BaseTable[Count] ), BaseTable[AddedOrRemovedTotal] = "AddedToParent" ) + 0 )
DataInsights
1 year agoSuper User
Try this calculated table:
NewTable =
ADDCOLUMNS (
VALUES ( BaseTable[FeatureKey] ),
"TotalRemoved",
CALCULATE (
SUM ( BaseTable[Count] ),
BaseTable[AddedOrRemovedTotal] = "RemovedFromParent"
),
"TotalAdded",
CALCULATE (
SUM ( BaseTable[Count] ),
BaseTable[AddedOrRemovedTotal] = "AddedToParent"
)
)
Add "+ 0" if you want 0 instead of blank:
NewTableWithZero =
ADDCOLUMNS (
VALUES ( BaseTable[FeatureKey] ),
"TotalRemoved",
CALCULATE (
SUM ( BaseTable[Count] ),
BaseTable[AddedOrRemovedTotal] = "RemovedFromParent"
) + 0,
"TotalAdded",
CALCULATE (
SUM ( BaseTable[Count] ),
BaseTable[AddedOrRemovedTotal] = "AddedToParent"
) + 0
)