Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

SWITCH function to present one value in whole row

I have SWITCH function like below....

koooala_0-1621518979090.png

 

I have function to return EBITA value in case group category is Admin 

koooala_1-1621519088887.png

It works well 

 

Currently the value is assigned to my matrix only in column with name category = Admin . 
I would like to assign the same value for other columns with different names. 

I would be happy for your resply with info what is the logic behind. 

THX!

4 REPLIES 4
SivaMani
Resident Rockstar
Resident Rockstar

@Anonymous, Can you share the expected output screenshot?

Anonymous
Not applicable

Below you can find expected outcome

koooala_1-1621578618401.png

value from admin column should be presented in other columns too (the places with red dot)

 

@Anonymous, Try this,

 

Instead of ADMIN_step2_cost centers[Group ] = "ADMIN"   

Filter( ALL(ADMIN_step2_cost centers[Group ]),ADMIN_step2_cost centers[Group ] = "ADMIN") 

 

Anonymous
Not applicable

Below code doesn't work (I have the same result - walu only in Admin column) 

20. Hourly rate - ADMIN = 
CALCULATE([10. EBITA LEVEL (CURR)],All('ADMIN List'),FILTER(ALL('ADMIN_step2_cost centers'[Group ]),'ADMIN_step2_cost centers'[Group ]="Admin"))

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.