Switch DAX formula error - Tricky

Hi Anonymous

From the code you've posted, the SWITCH function call on the very last line looks strange.

Specifically, the final SWITCH's intended first argument seems to be missing, and the other pairs of arguments seem to be the wrong way around.

I'm guessing a bit, but did you intend:

SWITCH ( ______, "Reported", NSales, "NOE", NSales1, "Organic", Organic, BLANK() )

Also you haven't used the InorganicMeasure variable after defining it. Not sure if that is supposed to be the first argument of SWITCH here.

Regards,

Owen

Sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

That being said, what error are you getting? Is this a column or measure?

The way you have it structured, I believe you want this instead:

% Reported Central 2 = 
VAR ReportingMeasure = SELECTEDVALUE(Reporting[Reporting])
VAR InorganicMeasure = SELECTEDVALUE(InOrganic[InOrganic])

VAR NSales =
        SWITCH(
		ReportingMeasure, 
		"Reported", [NSvPY1% (Reported PY)],
		BLANK()
	)

VAR NSales1 =    
        SWITCH(
    		ReportingMeasure,
		"NOE",[NSvPY3% (NOE @ PY Rate)], 
		BLANK()
	)  

Var Org1 =         
        SWITCH(       
    		InorganicMeasure, 
		"Organic",[% Organic Growth Movement],
		BLANK())        

Return

SWITCH(
	ReportingMeasure, 
	"Reported",NSales,
	"NOE",NSales1, 
	Org1
)

But this seems like it could be way simplified:

% Reported Central 2 = 
VAR ReportingMeasure = SELECTEDVALUE(Reporting[Reporting])
VAR InorganicMeasure = SELECTEDVALUE(InOrganic[InOrganic])

Var Org1 =         
        SWITCH(       
    		InorganicMeasure, 
		"Organic",[% Organic Growth Movement],
		BLANK())        

RETURN
SWITCH(
	ReportingMeasure,
	"Reported",[NSvPY1% (Reported PY)],
	"NOE",[NSvPY3% (NOE @ PY Rate)],
	Org1
)