CUBEMEMEBER - Dimensions and Attributes in PowerBI

[Anonymous]

Hello I am trying to move a multidimentional cube to PowerBi. I did the data trasnformation then the relationships and hierarchies. I created the measures as well but not the Dimensions and Attributes related(and here is my problem).

What I want to do is to create a connection between powerbi and an excel sheet to have a customized report. I successfully created the connection and I was having most of the results needed specially for the calculation columns that are mainly based or related to the Measures in PowerBI. My issue is with the CUBEMEMEBER function which is not showing me the values I need which I do believe this is happening because in PowerBI I did not create any Dimensions and Atrributes which I am not sure can be done in PowerBI.

The idea is to have a connection between the excel and powerbi instead of multidimentional cube.

Example of the issue:

-  I am was using this CUBEMEMEBER function to retreive the description column when ID is 1 and it was working fine when the connection is with multidimentional cube while with powerbi it is showing me the ID (1) where i do not need this and i do believe that this is happening just because the dimensions(attributes) are not well created in PowerBI and am not sure this can be done.

=CUBEMEMBER(". Connection","[Cash Flow].[CASH FLOW ID].&[1]")

note: that the [Cash Flow] represents the dimention and the [CASH FLOW ID] represents the attribute which has a keyname as original ID columns and Name columns originally the description.

Your help will be really appreciated.

Thanks

[Anonymous]

I need to replace the cube by powerbi when I create the connection with excel that uses the CUBEMEMEBER, CUBEVALUE, CUBESET...

So,

What I want is not to do the same logic in PowerBI based on the CUBEMEMBER but the issue how I can create Dimensions and attributes in powerBI similar to what I have in the cube so the CUBEMEMEBER function I have right now in excel can return the same results when I create the connection between the excel report and powerbi instead of the cube. 

[Anonymous]

Hi @Anonymous 

Logic similar to the CUBEMEMBER function in Excel can be implemented in Power BI by creating calculated columns or metrics. Here's an example:

“Table”

Create a measure.

Measure = 
CALCULATE(
    MAX('Table'[Description]),
    FILTER(
        'Table',
        'Table'[CASH_FLOW_ID] = 1
))

Create a column.

Column = 
IF(
    'Table'[CASH_FLOW_ID] = 1,
    'Table'[Description], 
    BLANK()
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.