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
Anonymous
Not applicable

Measure for Calculating the Percentage

Hello All,

      I have a table with columns Financial Month, Product, Amount Sales. I want to calculate percentage based on Total Amount sales of each product divided by total sales.  Matrix.PNG

So, the percentage for Beverage should be (252/1204)*100 and same for each product. 

Can anybody help me with  DAX expression for the above condition.

 

Thanks,

James

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Have a look at this post.

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Have a look at this post.

 

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.