Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am building the matrix visual
input
Group | Status |
1 | B |
2 | A |
3 | C |
matrix that i got to is (each 1 is a count)
Group | A | B | C |
1 | 1 | ||
2 | 1 | ||
3 | 1 |
i need to multiply each count by 80
Group | A | B | C |
1 | 1*80 | ||
2 | 1*80 | ||
3 | 1*80 |
since each column is a transposed row, i dont know how to refer to it. maybe there is an easy way. i.e. calculated A
thank you
Solved! Go to Solution.
Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.
thank you . works great.
one more question if you dont mind.
step 2 that i need to do is to find the difference between columns B and C (result of transposing).
to provide more context i will provide a better example
Group | A | B | C | still in progress |
1 | 3 | 3 | 1 | =3-1 |
2 | 1 | |||
3 | 3 | 3 | 1 | |
Group | A | B | C | Still in progress |
1 | 240 | 240 | 80 | =240-80 |
2 | 80 | 0 | 0 | |
3 | 240 | 240 | 80 |
Without context I would say that you just need to create a measure like Measure = COUNTROWS(Status)*80 and put in the "Values" of the Matrix.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |