Forum Discussion
Solved
Assistance Needed with DAX Calculation
Hi all, I'm new to Power Bi and I'm having an issue with a calculation. I am trying to calculate the share of sales an item holds. This is done by dividing the number of items sold by the Total S...
Hi 5B ,
How about this:
Here the DAX code for the measure:
Measure = DIVIDE ( SUM ( 'Table'[Qty] ), CALCULATE ( SUM ( 'Table'[Total Sales] ), ALL ( 'Table' ) ) )Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hi 5B ,
How about this:
Here the DAX code for the measure:
Measure =
DIVIDE (
SUM ( 'Table'[Qty] ),
CALCULATE (
SUM ( 'Table'[Total Sales] ),
ALL ( 'Table' )
)
)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Hey Tom,
It worked! Thank you.
I added in
FILTER(ALL('Table'), 'Table'[Date] IN VALUES('Table'[Date]))
Really appreciate it!
