Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Insert Measure or Column for Sumx column chart

Hi there,

I have a set of data that I would like to calculate 'Material C' and 'Material F', whereby
Material C= Material A + Material B
Material F= Material D + Material E
 
I created 2 new measures but can't add these 2 up to show 'Material C'.
SUMX('Table',IF('Table'[Material]="Material A",'Table'[Value]))
CALCULATE(SUM('Table'[Value]),FILTER('Table','Table'[Material]="Material B"))
 
OrganisationMaterialValue
AMaterial A10
BMaterial B20
CMaterial A20
DMaterial B30
EMaterial A10
AMaterial B20
BMaterial A10
CMaterial B30
DMaterial A30
EMaterial B40
AMaterial D10
BMaterial E20
CMaterial D20
DMaterial E30
EMaterial D10
 
Ultimately, I want to be able to plot into Clustered column chart, with X-axis being 'Organisation' and Y-axis being the comparison between 'Material C' and 'Material F' (as below).
 

 

 
 
 
 
 
 
Any help is appreciated! Thanks in advance!
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Anonymous,

     

    I can add your 2 measures, anyway try with the following 2 measures:

     

    Material C =
CALCULATE (
    SUM ( Table[Value] ),
    Table[Material] = "Material A"
        || Table[Material] = "Material B"
)
    Material F =
    CALCULATE (
     SUM ( Table[Value] ),
     Table[Material] = "Material D"
     || Table[Material] = "Material E"
    )

    Then you can plot Clustere Column Chart:

     

     

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous,

     

    I can add your 2 measures, anyway try with the following 2 measures:

     

    Material C =
CALCULATE (
    SUM ( Table[Value] ),
    Table[Material] = "Material A"
        || Table[Material] = "Material B"
)
    Material F =
    CALCULATE (
     SUM ( Table[Value] ),
     Table[Material] = "Material D"
     || Table[Material] = "Material E"
    )

    Then you can plot Clustere Column Chart: