Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello All,
In fact I created some measures to display on a Table or Matix visual but I need your Help :(.
the client need this view :
I created all measures X, x1 x2 x3 but I can't show them vertically like the visual in Excel and how can I do to calculate the Percentage?
Can I do it dynamically based on the first Measure (in my Case X is 100% and the other % are calculated on these value like shown in the exemple) ?
Thanks in advance for your help
Taddi
Solved! Go to Solution.
There's a way to achieve this with a disconnected table.
Please refer to the sample pbix
Hi @Anonymous if I'm understanding you correctly you have a bunch of measures that you want to show the percentage of in terms of measure X.
That should be fairly easy...
DIVIDE(
MeasureX1,
MeasureX,
BLANK()
)
and repeat the format for the others. Hope this helps...
Hello,
In fact what I need to do is to calculate automatically all in one measure in accordance with the line containing x1,x2,x3 ...
I tried to use SelectedMeasure() but no success...
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |