Forum Discussion

Regular Visitor

2 years ago

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...

Need Help

tackytechtom
2 years ago
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/

chonchar

Helper V

2 years ago

Hi, 5B

I will try my best to help. Try this:

Total Shares Sales =

VAR _TotalSales =

CALCULATE(

[Total],

ALL('TableName'[TotalSales])) // Your table name goes in 'TableName'

Return

DIVIDE(

[Total Sales],

_TotalDomains,0)

Best,

Cam

Forum Discussion

Assistance Needed with DAX Calculation

Related content

DAX assistance needed

Need Assistance with Dax : Previous Year Sales Calculation

Need a assistance with DAX calculation

Need Assistance || Microsoft fabric || Direct Lake Mode

Need assistance with DAX Calculation