How to sum up few rows based on another column

[Anonymous]

Hi,

I want to sum up the not covered & covered column based on their region in power BI

[negi007]

@Anonymous  You can use below expression 

Total_Cov_NonCov= SUMX(TableName,TableName[Column1]+TableName[Column2])

Total_Cov_NonCov= SUMX(Covered,Covered[Covered]+Covered[Not covered])

[amitchandak]

@Anonymous , Try one of the two

Total = SUM (Table[Covered]) + SUM(Table[Not Covered])

Total = SUMX(Table,[Covered]+ [Not Covered])

[annaselway]

Hi @Anonymous, 

From your message are you looking to add together th values of not covered + covered per reion, or sum not covered total for one region and covered total for one region? 

If the latter you want to create a measure to sum the values, you'd create one for not covered and one for covered. 

TotalNotCovered = var region= [Region]
RETURN
CALCULATE(
	SUM('YourTable'[NotCovered])
	ALL('YourTable'),
	'YourTable'[Region] = region
)

[Anonymous]

Hi @annaselway

I want to sum up covered based on region & same for uncovered, but am getting this warning message, can you please help me

[v-easonf-msft]

Hi , @Anonymous 

The screenshot is not clear enough to  recognize the error message .

If possible,could you share  a sample pbix for testing?

Does @annaselway ‘s  formula  work?

TotalNotCovered =
VAR region =
    MAX ( 'Table'[Region] )
RETURN
    CALCULATE (
        SUM ( 'Table'[NotCovered] ),
        ALL ( 'Table' ),
        'Table'[Region] = region
    )

Best Regards,
Community Support Team _ Eason

[negi007]

@Anonymous  Hi Jack. I do not think you need to create a measure in this case. You just need to put the region in the slicer or column if you are using matrix visual and then put covered and uncovered in value. See below screenshot for help

[Anonymous]

@negi007 , i want to use the sum value in a different chart, thats the reason am trying to create a measure

[jdbuchanan71]

@Anonymous 

This measure will add the two amounts together. 

Total = SUM ( YourTable[Covered] ) + SUM ( YourTable[Not Covered] )

Then you put the region and that measure in a table to show your value.