The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
I have created a running total DAX formula as below:
RunningTotal = CALCULATE( SUM( Opportunity[Sales Price (DKK)] ); FILTER( ALLSELECTED( Opportunity ); Opportunity[Close Date] <= MAX( Opportunity[Close Date] ) ) )
That formula works. However, I would like to add the filter below as well - but I can't seem to get that working:
Opportunity[Pipeline Category] = "Won"
Any input is appreciated.
Solved! Go to Solution.
@nielfxrm Please try changing the SUM function inside the CALCULATE as below:
SUMX(FILTER(Opportunity, Opportunity[Pipeline Category] = "Won"), Opportunity[Sales Price (DKK)])
Proud to be a PBI Community Champion
I tried to following this method but get an error
If i remove the " ;" then it tells me the Fileter argument is incorrect
@nielfxrm Please try changing the SUM function inside the CALCULATE as below:
SUMX(FILTER(Opportunity, Opportunity[Pipeline Category] = "Won"), Opportunity[Sales Price (DKK)])
Proud to be a PBI Community Champion
Thanks @PattemManohar. That did the job.
I was trying to add the filter somewhere else in the formula.
Cheers.
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |