Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |