Forum Discussion
Helper IIISum qty from 2 matrix
Hello,
I have 2 matrix A & B in report view. Which A and B are created by other measures.
Matrix B PINK column measure:
PINK B = CALCULATE(SUM('Combine data'[Projection Qty])*2.43, FILTER('Combine data', 'Combine data'[Brand] = "PINK"))
I want to create a new measure to sum the A & B value (e.g. 88745+426814.92) .
I use Sum Pink A & B = [PINK A] + [PINK B]
to write the measure but the total is not correct. How to write the measure?
Thanks.
2 Replies
- Ritaf1983
Super User
Hi pang22
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523 Hi pang22 ,
In Power BI, the result of a measure can change based on the context in which it’s used, such as the row, column, or filter context. When you’re adding the measures together, Power BI is not simply adding the total of each measure, but rather it’s calculating the measure for each context and then adding those results together.
Therefore, we need more details, such as the fields and filters in the matrix A and B, and ideally a sample file that we can test, taking care to remove private information.Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
