Forum Discussion
Solved
Aggregate a column in Table1 based on Match and No Match values from Table 2
Hi, I have two tables that are currently linked (Relationship) as one to many. I want to create DAX measures that will help generate Visual 1 and Visual 2. Any advice on how this can be achieved ...
Hi FMF ,
Please have a try.
Create a measure.
KPI_DAX = var result_1= CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Match")) var result_2=CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Not Match")) var answer = IF([Check]="Match",result_1,result_2) return answerBest Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi FMF ,
Please have a try.
Create a measure.
KPI_DAX =
var result_1= CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Match"))
var result_2=CALCULATE(SUM('Table 1'[KPI]),FILTER(ALL('Table 1'),'Table 1'[Company]=SELECTEDVALUE('Table 1'[Company])&&[Check]="Not Match"))
var answer = IF([Check]="Match",result_1,result_2)
return answer
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks Polly,
Please can you share the DAX measure formula for [Check]