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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
athul00000
Frequent Visitor

How to remove a table only from the total columns

hello Team, 

 

Can you please help to how to remove the marked from a table. I just need to remove the Status column from both the Total column and Total Rows.

athul00000_0-1691502482642.png

The formula for Status used is 

Status = IF('SO Report'[fl_TypeDay] = "Working Day (Sales)", "📗", IF('SO Report'[fl_TypeDay] = "Sick Leave", "", IF('SO Report'[fl_TypeDay] = "No Sale Day", "📕", IF('SO Report'[fl_TypeDay] = "Day Off", "", IF('SO Report'[fl_TypeDay] = "Training Day", "📚", IF('SO Report'[fl_TypeDay] = "Holidays", "🟣", IF('SO Report'[fl_TypeDay] = "Administrative Day", "🟫","")))))))

 

2 REPLIES 2
Greg_Deckler
Super User
Super User

@athul00000 (1) The New Hotness (Custom Matrix Hierarchy) - Microsoft Fabric Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
athul00000
Frequent Visitor

Also i need to keep the Sales columns and Shift column in the Total section

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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