Summarize in rows

[KatkaS]

Dears,

I have another simple question, which I'm not able to figure out... 😞

I try to summarize values in the table based on Department...

COuld you please help me with the measure..?

Thank you very much!

[Greg_Deckler]

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[KatkaS]

Thank you, Greg, for looking into this...

I was not able to reproduce your solution:( I fount a bit different way using measure 

FTEs AtR = SUMX(CALCULATETABLE('KPI1_FTE breakdown','KPI1_FTE breakdown'[Department] = "AtR"),[ASC]), but this work only with data in one column. When I tried to add more columns, measure doesn;t work 

FTEs AtR = SUMX(CALCULATETABLE('KPI1_FTE breakdown','KPI1_FTE breakdown'[Department] = "AtR"),[ASC] || [CHU] || [CHC])

Below you will find example - I need to calculate how many FTEs from AtR (or PtP) are working for all entities (ACS, CHU, CHC etc - all together).

Thank you!

Department	Name	ASC	CHU	CHC	+ other 10+ COLUMNS...
AtR	Janet	0.1	0.5	1
AtR	Bil	0.05	0.25	0.3
AtR	Tony	.08	0.8	0.5
PtP	Jessica	1	0.3	0.25
PtP	Maggie	0	1	0.65

[az38 · Accepted solution]

Hi @KatkaS 

maybe you need smth like

Measure = 
CALCULATE(
SUMX('KPI1_FTE breakdown', [ASC] + [CHU] + [CHC]),
ALLEXCEPT('KPI1_FTE breakdown', 'KPI1_FTE breakdown'[Department])
)

[KatkaS]

Oh yes, this is exactly what I needed. Thank you!!!