Hi. The below DAX gives me the error:
'The syntax for ')' is incorrect. (DAX(IF(ALL('Semantic DimSource'[LocationCode_B]<))' if you can help please.
To me it's a simple dax so that if SourceLocationCodeB is blank it would give me SourceLocationCodeZ, otherwise give me MeterLocationCodeB and can't see a syntax error there;
Status.Stacked = IF(ISBLANK(ALL('Semantic DimSource'[LocationCode_B],'Semantic DimSource'[LocationCode_Z],'Semantic DimMeter'[MeterLocationCode_B]))
'The syntax for ')' is incorrect. (DAX(IF(ALL('Semantic DimSource'[LocationCode_B]<))' if you can help please.
To me it's a simple dax so that if SourceLocationCodeB is blank it would give me SourceLocationCodeZ, otherwise give me MeterLocationCodeB and can't see a syntax error there;
Status.Stacked = IF(ISBLANK(ALL('Semantic DimSource'[LocationCode_B],'Semantic DimSource'[LocationCode_Z],'Semantic DimMeter'[MeterLocationCode_B]))