Forum Discussion
Solved
Create a Measure/Solution aggreagteing Data and comparing 2 columns
Hello, I'm working with a dataset which is basically structured like this: The columns Customer_1 and Customer_2 refer to the same Customer. What I would like to do is create a Matrix Visu...
Hi AC123 -you don’t need to create a new table or model relationship if you just want to align Customer_1 with aggregated values from Customer_2.
create a measure with below filter condition as follow:
Total Transactions_MatchedToCustomer1 =
CALCULATE(
SUM(Data[Transactions_Customer_2]),
FILTER(
ALL(Data),
Data[Customer_2] = MAX(Data[Customer_1])
)
)This works please check.
Thank you for the feedback. Is there any possibility to achieve this with DAX without changing the structure of the data set by unpivoting and pivoting it?