Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am trying to do the below calculation to sum the Annual GP based a couple of filters, but as soon as I try and do the filter actualclosedate>X then it doesn't work and just sums all Annual GP. See below formula, can someone take a look and see where I am going wrong.
Solved! Go to Solution.
Hi @ARCherry ,
Try this measure:
AGP Removed =
CALCULATE (
SUM ( Opportunity[Annual GP] ),
(Opportunity[new_ContractType] = 279640002
|| Opportunity[new_ContractType] = 279640000
|| Opportunity[new_ContractType] = 957500000) &&
Opportunity[ActualCloseDate] > DATE( 2020, 1, 15)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsGive date like
date(2020,1,15)
Hi @,
Can you please try the following DAX expression please:
AGP Removed = CALCULATE(
SUM(Opportunity[Annual GP]),
FILTER('Opportunity',
(Opportunity[new_ContractType]=279640002 || Opportunity[new_ContractType]=279640000 || Opportunity[new_ContractType]=957500000)
&& (Opportunity[ActualCloseDate]>15/01/2020)
)
)
If this helpf give Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Hi @ARCherry ,
Try this measure:
AGP Removed =
CALCULATE (
SUM ( Opportunity[Annual GP] ),
(Opportunity[new_ContractType] = 279640002
|| Opportunity[new_ContractType] = 279640000
|| Opportunity[new_ContractType] = 957500000) &&
Opportunity[ActualCloseDate] > DATE( 2020, 1, 15)
)
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks Miguel! That has worked.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |