Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello
I would like to know how could I get a total count of how many values I have displayed in my matrix like below example:
LINES | day 1 | day2 | day 3 | total |
top1 | ||||
top1.1 | blank | blank | 5.67 | 1 |
the values of the matrix are comming from a measure: VAR A =
Solved! Go to Solution.
@Anonymous , Create a measure with summarize with all rows and columns
example
measure =
var _tab = summarize(Table, Dim[dim1], Dim2[dim2], "_1", [measure])
return
countx(_tab, _1)
@Anonymous , Create a measure with summarize with all rows and columns
example
measure =
var _tab = summarize(Table, Dim[dim1], Dim2[dim2], "_1", [measure])
return
countx(_tab, _1)
One last thing,
As you can see below the total in the corner is 35 so the value I got is 15.10%.
However, this value I need it to be the sum of the 3 items (in this case) divided by 3items OR the sum of each value per day divided by number of days.
do you have any idea to sort out this problem?
thanks!
It worked!
Thanks
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.