Forum Discussion

Romain39's avatar
Romain39
Copper Contributor
Jul 21, 2023

Cube function and measures

Hello,
I'm learning to use the cube function, from someone else's file.
But I can't figure out how to incorporate a scale into my results.
The file uses this formula to, I think, format the results: =MEMBRECUBE("ThisWorkbookDataModel";"[Measures].[k€]")
Even if I copy the formula, the result returns #N/A.

Does anyone have a solution, please?

Formulas and Functions

2 Replies

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Jul 21, 2023

    Romain39 

     

    https://support.microsoft.com/en-us/office/cubemember-function-0f6a15b9-2c18-4819-ae89-e1b5c8b398ad: Returns a member or tuple from the cube. Use to validate that the member or tuple exists in the cube

     

    If =CUBEMEMBER("ThisWorkbookDataModel";"[Measures].[k€]") returns #N/A the most probable reason is: no measure named 'k€' exists in your Data Model. If such a measure exists the result will be k€ and nothing else

     

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jul 21, 2023

    Romain39 

    I guess MEMBRECUBE in English version is CUBEMEMBER. In general it shall work. If you type from scratch it shall suggest you available options, did you try?

Resources