Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
I want to add column of monthly budget calculate from yearly budget filter with multiple rows same prduct categeory which are same with number of months.
I used follwing dax to add column it is not working.
Solved! Go to Solution.
Hi @Anonymous
The error is the result of ALLSELECTED being added as 3 arguments of DIVIDE and it should be in CALCULATE, try this.
Monthly forecast =
CALCULATE(
DIVIDE(
SUM( Sales[Budget] ),
COUNT( Sales[Month] )
),
ALLEXCEPT( Sales, Sales[Brand] )
)
Hi @Anonymous,
Please provide some dummy data with similar data structure and expected results to help us clarify your requirement and test to coding formula on it.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Anonymous
Try.
Monthly forecast =
CALCULATE(
DIVIDE(
SUM( Sales[Budget] ),
DISTINCTCOUNT(Sales[Brand] )
)
)
Hello @Mariusz ,
There is no error but data is wrong.
I changed as followed and there is error.
Best Regards,
SweZin
Hi @Anonymous
The error is the result of ALLSELECTED being added as 3 arguments of DIVIDE and it should be in CALCULATE, try this.
Monthly forecast =
CALCULATE(
DIVIDE(
SUM( Sales[Budget] ),
COUNT( Sales[Month] )
),
ALLEXCEPT( Sales, Sales[Brand] )
)
@Anonymous
are you creating a measure? Maybe you can try
Monthly forecast =
DIVIDE(CALCULATE(SUM(Sales[Budget},ALLEXCEPT(Sales,Sales[Brand])),DISTINCTCOUNT(Sales[Month] ))
Proud to be a Super User!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |