Some special table I am not able to create in Power BI

[Anonymous]

Hello,

I need your helg again.

I would like to create a table which looks like:

My problem is, my solution looks like that:

I calculated 4 different measure, for each region one. I cannot use a matrix table and put sales to Values, regions to rows and so on.

I had to calculate a measure for every region, because in every measure I had to heed some different aspects....

I hope, I could make the problem clear enough.

Does  somebady have an idea to solve my problem?

Thank you for your help!

Christian

[v-juanli-msft]

Hi @Anonymous

Could you share some data for better analysis?

Best Regards

Maggie

[Anonymous]

Hello,

sorry for the chaos I posted!

I would like to have the following table in Power Bi:

 

The data model I created:

 

I can´t merge "Tab_PLAN" with remaining tables in the model. I can´t create a 1 to m connection, because my PLAN table looks like that:

I get the table from a different department.

Do I have to create a supporting table to get a connection to my other tables or is there another way?

I calculated every single measure and they work.

It looks like that:

 

But I´m not able to put the measure in the right form as in the first picture

I hope my post is more structured right now and it´s more clear what kind of solution I would like to have.

If not, please tell me, so I can learn to structure my issues more and make it more clear to others.

Thank you for every help!!

Best regards

Christian

[v-juanli-msft]

Hi @Anonymous

From above, Table_Item and Table_Play have the same column "category", but they all have repetitive values, right?

If it is this scenario, you could create a new table with one distinct column

new table=DISTINCT(Table_Play[category])

then edit relationship

Table_Item(many)-new table(one)-Table_Play(many)

Best Regards

Maggie

[Anonymous]

HI @v-juanli-msft,

thanks for your answer.

They aren´t repetitve values. The columns just have the same name. I changed the name to make it more clear.

Those are tables I use:

Plan Table

ITEM:

Customer Table:

And a Calendar Table.

What do I have to do know?

Thanks for your help!!

Christian

[v-juanli-msft]

Hi @Anonymous

After testing with your four tables, i can't calculate the Revenues as picture below shown from the Calendar Table[revenues].

Could you tell me how to calculate this result? this means which column from which table you use to calculate and which column it calculates based on.

Best Reagrds

Maggie

[Greg_Deckler]

Nope, not clear. Not sure why you can't use a matrix. 

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