Totalling from a separate table

[TimK]

Hi,

Hope someone can help with what i am sure is a pretty easy answer!!!!

Basically i have 2 tables.  The first table (Table1) is as below:

The second table (Table2) is created from a different source, and specifically it has more data than above.

You will see in the table above, the last 4 lines do not have data when you link by [Project],[DD],[L/M],[Date] which i have demonstrated by using [Concatenate 1]

What i am strugling with, is to achieve what is shown in the column [Value 1].  These figures are the sum based on [DD],[L/M],[Date] which i have demonstrated by using [Concatenate 1]

I have a Relationship between [Concatenate 2]

I have tried by using:

[Value 1]= Calculate(SUMX('Table1'[Value]),ALL('Table1'[Value]),'Table1'[DD]=[DD],'Table1'[L/M]=[L/M],'Table1'[Date]=[Date]))

But it is just returning the figures in [Value 2]

Thanks for any help 🙂

[TimK]

hi Binbin Yu

Thank you for your help...........

I have placed the Excel data file here

Unfortunatel;y i am unable to share the PowerBI

Thanks for your help with this

[Anonymous]

Hi @TimK ,

Could you please provide the desensitized source data or pbix file? it would be very helpful to me for testing.

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_ Binbin Yu

[TimK]

so the PowerBI is attached here

You will see i have a tab 'Monthly Totals' which is the base data.

The second tab 'Row Totals' shows the totals for each row.

I am after a Measure that divides the monthly totals by the respective 'Row Total' - for example in the first row we would have 23/102; 24/102; 26/102 etc......... at the Project / DD / LM level

I am also after a measure that gives me the same calculation but at the higher level - without the DD level - so at Project / LM level

I am struggling with both these Measures - can anyone help?

Thanks