Forum Discussion
Totalling from a separate table
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 🙂
3 Replies
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 Yuso 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
