Cube Formula Help in PowerPivot

[deharris]

I have an Excel 2016 PowerPivot data model where I'm trying to find a member value based on whether 4 other member values exist. A sort if "if" statement. If Values A, B, C & D exist, bring me back value E. Value E can be 1 of three things based on values A-D being found. I've researched CUBEMEMBERPROPERTY but it doesn't seem to work with PowerPivot. To be clear, I'm looking for a label, not a number. I'm new to all the syntax for the more detail the better.

"Cube Formula"
"ThisWorkbookDataModel"
Values A-E all come from the same table.

thank you for any help.​

 

[macfuller]

There are NotEmpty and Exists parameters in MDX but I don't have expertise myself.

Assuming that A-D are variables and not hard-coded you could try this via slicers. Assuming that values A-D are possible values within the table set slicers for each of the fields. Next, put the values of the slicers into separate cells using CUBERANKEDMEMBER("ThisWorkbookModel",Slicer_A,1) etc. Assume you put that Slicer A formula into $A$3 etc. Finally select a measure and do an IFERROR(CUBEVALUE("ThisWorkbookModel","

.[Column A].[" & $A$3 & "]", "

.[Column B].[" & $B$3 & "]"... etc and end up with ,"[Measures].[MyMeasure]")) If there's an error then there's no value E. If there's not an error then you can trap for the preferred conditions of the statement to decide which value E to return.