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
How to create DAX IF for conditional formating with 2 categories
I tried this but give error
KPI_Points = IF((SUM(Sales[Points] ) && Sales[WO_Type] ) < (SUM(KPI[Points]) && KPI[[WO_Type] ) ,"Red","Black")
Thank
@Anonymous , if conditions are wring they need to be like the example
KPI_Points = IF(SUM(Sales[Points] ) <100 && KPI[[WO_Type] = "A" ,"Red","Black")
Change as per need.