Get name based on ID from Power BI dataset Excel - - Cubememberproperty?

[AnnDuch]

Dear all

I have a question about using the data set from Power BI in excel. 

I use the cubemember formula with a reference to a cell. eg.: =CUBEMEMBER("Budget 2023 Report";"[Product Data].[Material ID].&["&D2&"]"). This works fine.

However, based on this Material ID, I would like to extract as well the Material Description that is in the same table ([Product Data].[Material Description]). I search on the internet and thought Cubememberproperty might work. But I get #N/A. 

Does anyone know if this is possible and how? 

Thanks a lot for your help!

[AnnDuch]

Thanks a lot for your reply. I was hoping to have a more "simple" solution (wo additional measures). But at least we can work with this. 

[wdx223_Daniel · Accepted solution]

you can create a measure to get the item description according to the item code. say, new measure=max('Product Data'[Material Description])

then use CUBEVALUE to get it

=CUBEVALUE("Budget 2023 Report";"[Product Data].[Material ID].&["&D2&"]","[Measures].[New Measure]")