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

Newbie DAX question

Hello.

 

I never used DAX and could not find a proper solution a surely easy question.

 

I have a measure with the total sales. In a table I also have a column with the sales of each shop. I need to discard some shops, but we have to compare with the total. If I filter some shops, the total chances, but I need to use the total even of the discarted shops.

 

So, how can I configure a column with the formule "previous column / Totals measure"?

 

Thanks

1 ACCEPTED SOLUTION
Anonymous
Not applicable

3 REPLIES 3
tamerj1
Super User
Super User

Hi @Anonymous 
You need to do simething like 
Totals measure =

CALCULATE ( [Sales], ALL ( TablrName[Shop] ) )

Ofcourse it depends on the filter contectx of the table visual i.e. what other columns involved in the table.

Greg_Deckler
Super User
Super User

@Anonymous Use ALL. You will likely need to have a slightly different calculation for your total line. This Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

Thank you!!

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.

Top Solution Authors