Forum Discussion
Anonymous
5 years agoNot applicable
Need Help with DAX IF Condition
Hi Community, I'm trying to convert a Custom Column into a Measure in Power BI, but I can this error, can someone help me with this. Error Message below. Error Message: MdxScript(Model) (...
- 5 years ago
Ah. Yeah, measures shouldn't need extra aggregations.
I think your measure could be simplified quite a bit. I'd suggest starting from something like this:
MeasureName = VAR Channel = SELECTEDVALUE ( Input[Channel] ) VAR Customer = SELECTEDVALUE ( Input[Customer] ) VAR Brand = SELECTEDVALUE ( Input[Brand] ) RETURN IF ( Channel = "All" || [NR/HL Country Base] = 0 || CONTAINSSTRING ( Channel, "CENTRAL" ) || CONTAINSSTRING ( Customer, "CENTRAL" ) || Brand = "RESIDUAL STOCK" || CONTAINSSTRING ( Brand, "CENTRAL" ) || ABS ( [NR/HL Channel Base] - [NR/HL Channel AC] ) > 500, 0, 1 ) / 1000Note that CONTAINSSTRING is not case-sensitive, so you don't need upper.
Anonymous
5 years agoNot applicable
Hi Anonymous ,
It's hard to reproduce the scenario, can you share some sample data to us?
Best Regards,
Jay