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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Yollies
Helper I
Helper I

% Column adding up and not showing the line %

Hi.  I have a straight set of data. In my query i have a calculated column Gross Profit and a calculated column for GP%. Then i bring the table in and have option to select say 2 months then it adds th % and not keep it per linePic 1.PNGThe GP5 column is adding up instead of showing the real % . Note that i have a filter on month and i have selected 5 monthThe GP5 column is adding up instead of showing the real % . Note that i have a filter on month and i have selected 5 month

 

 

1 ACCEPTED SOLUTION

@Yollies

 

Create a new Measure and NOT a Column and add this formula:

 

Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)

View solution in original post

8 REPLIES 8
Yollies
Helper I
Helper I

How do i share the file?

 

@Yollies

 

Share it through a dropbox link or upload it to a website and share it with us (e.g. wetransfer.com)

What email address do i add in wetransfer?

 

thanks

@Yollies

 

Yours so as to get the link and then share the link with us

@Yollies

 

Create a new Measure and NOT a Column and add this formula:

 

Measure = divide(SUM(ACT[GPROFIT]),SUM(ACT[NSV]),0)
themistoklis
Community Champion
Community Champion

@Yollies

 

What is the formula that you are using? Any chance to share the workbook with us?

Mask any sensitive data

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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