How to calculate Actual Sales per day using DAX

0
votes

I'm trying to get Actual Sales per day using DAX howver I can't able to get the Actual Sales Per Day using DAX Expression.

enter image description here

I'm using below DAX to calculate Total No. of days.

b:=CALCULATE(COUNT(DimDate[Date]),DimDate[CY_Year]=YEAR(TODAY()),USERELATIONSHIP(Fact_Sales[Doc_Date],DimDate[Date]))

Please provide the correct formula.

1
ssasbusiness-intelligencetabulardaxmsbi
Please post your formulas for a and b – dotNetE
I already posted formula for b and a is nothing but sum of Sales Amount. – Jay Doshi

1 Answers

0
votes

Assuming [a] is a measure in the Data Model then you just create a new measure for Actual Sales Per Day as follows:

c :=
[a] / [b]

If [a] is not already a measure in the Data Model then create it first as follows:

a :=
SUM ( [SalesAmount] )