Forum Discussion
AND/OR Statements in DAX
Var ghosts =
CALCULATE (
COUNT ( '999_Funnel'[Sale Type] ),
FILTER (
'999_Funnel',
'999_Funnel'[Sale Type] = "Assay"
&& '999_Funnel'[_C_Annual Recurring Funnel Adj. (GC)] < 50)||
'999_Funnel',
'999_Funnel'[Sale Type] = "Assay"
&& '999_Funnel'[FV Units] > 0 ||
'999_Funnel',
'999_Funnel'[Sale Type] = "Assay"
&& '999_Funnel'[Capital Funnel Value (GC)] > 0) +
CALCULATE (
COUNT ( '999_Funnel'[Sale Type] ),
FILTER (
'999_Funnel',
'999_Funnel'[Sale Type] = "Equipment" && '999_Funnel'[FV Units] = 0 )||
('999_Funnel'[Sale Type] = "Equipment" && '999_Funnel'[Capital Funnel Value (GC)] = 0 && ('999_Funnel'[Sale Type] = "Equipment" && '999_Funnel'[Finance Type] = "Cash/Lease")|| ('999_Funnel'[Sale Type] = "Equipment" && '999_Funnel'[Monthly Recurring Funnel Value (GC)] = 0 && '999_Funnel'[Finance Type] = "Seed/Rental" && NOT('999_Funnel'[Product.Sales Product Line] = "Automation" || "Atellica Solution Components" || "IT"))))
There needs to be two statements added together. The first
Sale Type ="Assay" && (Recurring funnel is <50 EUR || FV unit > 0 || Capital funnel is > 0)
The second is Sale Type = "Equipment" && (FV units = 0 || (Capital funnel = 0 && Finance Type = "Cash/Lease") || (Recurring funnel = 0 && Finance Type = "Seed/Rental" && (NOT Automation || Atellica Solution components || IT)
I need that ^ in Power BI terms the picture I posted also explains it in words. I tried my hand at it but I know I am missing some parts Greg_Deckler
Hi, poweruser55
I didn't find any paranthesis issues, can you share detailed error message?
Best Regards,
Community Support Team _ Eason