Forum Discussion
Calculating sum using 2 tables and specific values in a column
Hi! I am trying to sum values using Dax but cant figure this one out for some reason even though it doesn't sound logically tough.
I have an Industry table with column named phase and another table named member summary with a column name of 75plus.
I am trying to figure out the new column = sum(phase) = "1B" + sum(75plus) does not equal "1B" so that these dont overlap with one another.
2 Replies
- parry2k
Super User
Anonymous Read this post to get your answer quickly. Provide some sample data and expected output.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 Hi Anonymous
Does 1B mean 1 billion?
Do you want to build a calculated column or a measure?
If you want to build a calculated column ,please tell which table you want to build it in.
And I am confused about your calculated logic. Please show me more details about your calculated logic, a screenshot of result may be better.
Can you give me a sample which will show me Industry and Member Summary Tables?
This may make it easier for me to understand your requirement.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
