Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |