summary in Matrix is not correct

[Sonne]

Hello,

First of all I have to say , i m an absolute beginner in Power BI. It is the first time i try to create a visualisation . I have several excel file and I have  already transferred this files successful to Power BI and got 8 tables.

I used a Matrix as visualisation .

CT description is coming from CMD table, Wert3  is coming from table7.

I know that the summaries in a matrix are not correct if I use Measures. I could manage to get the right summary if I only have one CT selected , because the formula I use is based on Wert3. But if I choose more than one CT the calculation is not right anymore.  The red marked entry is wrong.

The formula for weighted overall value is :

weighted overall value= var _table=SUMMARIZE('table7';'table7'[Wert3];"_per";[combined value]*[weighted value P03]) return SUMX(_table;[_per])

I assume the formula must be on Wert3 and on CT description, but as they are not coming from the same table, I have no idea how to get a second table in the summarize formula.

Is this possible at all? Or must I restructure the data somehow?

[kcantor]

@Sonne 

Can you provide us with a snip of your data model and relationships? Most frequently, you need dimension tables to use to populate the rows while the values will come from the fact tables. Your solution may be as simple as creating a dimension table for the descriptions and relating the tables. It could also be necessary to merge the tables together in a wider version. Without more informaiton on the source of the data and your relationships, this is a very broad question.

[Sonne]

Hello,

please see the Picture , i tried to show the relationship . All the tables are coming from different  , which i can not change. the only important data are the customer ids in CMD, and the wert3 values( 4 digit code) from Table 7