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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
shaya
Helper I
Helper I

Sum (%) column in MATRIX PREVIEW

I want to calculate profitability
A. Sale
B. Cost
C. Profit = (A-B)
S.% Profit  = ( A-B ) / A 

 

I would have expected the summary to be the same,
but rather that it sums up instead of calculating a percentage.

Especially in collaps up situation 

I have tried also this  Show Values As => Percent of Row Total  and all others 

 

Thanks

 

percent.png

1 ACCEPTED SOLUTION

Hello cs_skit

 

This is did not help (?) 

 

But it did solve the problem

 

Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))

 

I donwt know why...

Still, I learned a lot

Thanks 

View solution in original post

2 REPLIES 2
cs_skit
Resolver IV
Resolver IV

for profit and percentage do measures instead of calculated columns then it works:

Hello cs_skit

 

This is did not help (?) 

 

But it did solve the problem

 

Average CUSTNAME = AVERAGEX(KEEPFILTERS(VALUES('INV-AMI'[CUSTNAME])),CALCULATE(AVERAGE('INV-AMI'[profit%]))

 

I donwt know why...

Still, I learned a lot

Thanks 

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.