Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello All,
I am using Power Bi desktop to develop Dashboards.
I created a Dashbaord based on the following information:
DEPARTMENT | MONTHS | COUNTS | MONTH NUMNER |
WATER | FEB | 80 | 2 |
ELECTRICITY | MAR | 2 | 3 |
DMV | APR | 100 | 4 |
GAS | FEB | 20 | 2 |
WATER | MAR | 10 | 3 |
ELECTRICITY | APR | 5 | 4 |
DMV | FEB | 60 | 2 |
GAS | MAR | 5 | 3 |
WATER | JAN | 2 | 1 |
GAS | JAN | 5 | 1 |
DMV | JAN | 30 | 1 |
On based of above infomation I created a percentage column as:
Solved! Go to Solution.
Hi @sdhn ,
Please use the following calculated column:
Percentage =
DIVIDE (
'TABLE'[COUNT],
CALCULATE (
SUM ( 'TABLE'[COUNT] ),
FILTER ( 'TABLE', 'TABLE'[MONTHS] = EARLIER ( 'TABLE'[MONTHS] ) )
)
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @sdhn ,
Please use the following calculated column:
Percentage =
DIVIDE (
'TABLE'[COUNT],
CALCULATE (
SUM ( 'TABLE'[COUNT] ),
FILTER ( 'TABLE', 'TABLE'[MONTHS] = EARLIER ( 'TABLE'[MONTHS] ) )
)
)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@sdhn , Create a measure like this and use with month in visual
Percentage = DIVIDE(sum('TABLE'[COUNT]),calculate(sum('TABLE'[COUNT]), allselected('TABLE')))
or
Percentage = DIVIDE(sum('TABLE'[COUNT]),calculate(sum('TABLE'[COUNT]), all('TABLE')))
User | Count |
---|---|
93 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |