Forum Discussion
Solved
Sum unrelated values in Matrix
Hello, I want to sum three values from different unrelated tables in the same visual matix. Please find below matrix. The total should be the sum of below values. Please advice. Thank you ...
- Create three measures as given below. VMM Measure=sum(TableName[Visitor Mobile M]) LV Measure= sum(TableName[Local Visitor]) V Measure= Sum(TableName[Visitor]) And finally Create a Measure as Total Visitor= [VMM Measure]+LV Measure+ V Measure I hope it would help you.
hthota
Resolver III
Resolver IIICreate three measures as given below. VMM Measure=sum(TableName[Visitor Mobile M]) LV Measure= sum(TableName[Local Visitor]) V Measure= Sum(TableName[Visitor]) And finally Create a Measure as Total Visitor= [VMM Measure]+LV Measure+ V Measure I hope it would help you.