Forum Discussion
Direct & indirect Commodity
Hello Expert, I want to show 2 bar of commoditry: - Fisrt Bar: shows commodity that have amount when ( coontry of Import = country of Origin). - Second Bar: shows commodity that have amount when...
Hi,
Please check the below measures and the attached pbix file whether it suits your requirement.
Amount orging import same: = VAR _newtable = FILTER ( ADDCOLUMNS ( Data, "@origin", CALCULATE ( MAX ( Data[Country of Origin] ) ), "@import", CALCULATE ( MAX ( Data[Country of Import] ) ) ), [@origin] = [@import] ) RETURN SUMX ( _newtable, Data[Amount] )Amount orging import diff: = VAR _newtable = FILTER ( ADDCOLUMNS ( Data, "@origin", CALCULATE ( MAX ( Data[Country of Origin] ) ), "@import", CALCULATE ( MAX ( Data[Country of Import] ) ) ), [@origin] <> [@import] ) RETURN SUMX ( _newtable, Data[Amount] )
Jihwan_Kim
Super User
Super UserHi,
Please check the below measures and the attached pbix file whether it suits your requirement.
Amount orging import same: =
VAR _newtable =
FILTER (
ADDCOLUMNS (
Data,
"@origin", CALCULATE ( MAX ( Data[Country of Origin] ) ),
"@import", CALCULATE ( MAX ( Data[Country of Import] ) )
),
[@origin] = [@import]
)
RETURN
SUMX ( _newtable, Data[Amount] )
Amount orging import diff: =
VAR _newtable =
FILTER (
ADDCOLUMNS (
Data,
"@origin", CALCULATE ( MAX ( Data[Country of Origin] ) ),
"@import", CALCULATE ( MAX ( Data[Country of Import] ) )
),
[@origin] <> [@import]
)
RETURN
SUMX ( _newtable, Data[Amount] )You are a great.