Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hi @amitchandak ,
I have to show some data in a matrix visual
where in rows it contains Group , Division , Branch
In columns it contains Value , Target.
Group Division Branch Value Target
A IT Admin 25 60
Users 10 50
Workers 25 100
B Btech Admin 35 50
Users 25 100
C CSC Admin 45 100
Users 35 50
Contracts 55 75
For Every Group they had a different values and targets.
Now i have to show aggregate in that matrix visual like
for A - Value(25+10+25) / Target(60+50+100)
for B - Value(35+25)/ Target(50+100)
etc.,
So final result is
Group Division Branch Value Target
A IT Admin 25 60
Users 10 50
Workers 25 100
Aggregate total value / total target
B Btech Admin 35 50
Users 25 100
Aggregate total value / total target
C CSC Admin 45 100
Users 35 50
Contracts 55 75
Aggregate total value / total target
Please help me in solving this.
Thanks,
Krishh
Solved! Go to Solution.
@krrish116 , Can update your final result with the numbers. Not able to get that yet
@krrish116 , that you should get as subtotal ?
or add new measure
divide(sum(Table[Value]), sum(Table[Target]))
or
calculate(divide(sum(Table[Value]), sum(Table[Target])), filter(allselected(Table), Table[Group] =max(Table[Group])))
Hi @amitchandak ,
I want aggregate for each and every group in the place of subtotal?,
and the value and target are mesures not columns.
Thanks,
Krishhh
@krrish116 , do you want to remove the subtotal of division? Under subtotal, you have an option for Per Row Level Switch on and remove subtotal for division and branch as per need
Hi @amitchandak ,
The Value and Target and Subtotal is coming only for Branch.
The Aggregate mesures are not working on matrix visual, if i put that measure on visual then it is showing Blank.
Please help me to sort it out .
I need Aggregate for the bottom of each branch i.e Total Value / Total Target.
Plese let me know, if is not possible due to limitations then i will leave this issue.
Thanks for your support in every issue.
Thanks,
Krishh..
@krrish116 , Can update your final result with the numbers. Not able to get that yet
User | Count |
---|---|
93 | |
92 | |
85 | |
83 | |
49 |
User | Count |
---|---|
150 | |
142 | |
112 | |
73 | |
55 |