Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I use the following measure to compute % of things that occur each day of week for 5 years on a clustered column chart. Sometimes the % for a year may total 101% for example.
Can I add something to the measure to make sure each year the percentages equal 100%?
Hi,
Share some data to work with, explain the question and show the expected result. Please also ensure that you have a Calendar Table with a column of Week number.
hi @bdehning
Not sure about the logic, if limit to result to 100% is the only issue, you may try to change
RETURN
DIVIDE ( _count, _totalperyear )
to
VAR _pct =
DIVIDE ( _count, _totalperyear )
RETURN
IF(_pct<=1, _pct, 1)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |