Hi Community Experts,
I have a matrix visual which contains columns from multiple tables and a calculated measure.(sum)
The calculated measure gives the result correctly but when i add a conditional column, this measure (sum) splitts into partial sum which I don't need.
Would you please advise how to solve the issue?
Without conditional column
Column A Column B Measure
A 1 50
A 2 50
B 1 60
B 2 60
B 3 60
But when I add a conditional column, it show like this
Column A Column B Measure conditional column
A 1 20
A 2 30
B 1 10
B 2 8
B 3 42
Appriciate your help
Go to Solution.
Problem is solved. I used First(conditional coulum) in matrix visual.
Column A Column B measure First of conditional column
View solution in original post
Hi @Raaz ,
Thanks for sharing your solution here.
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!