The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
hi, can I know how to calculate percentage for this data . I want to calculate also for 47595 , 12828 as grand total
Solved! Go to Solution.
@AtchayaP , Assume you have two measure Employee has skill and Count of active directory ID
Create a new measure
= divide([ Employee has skill],[Count of active directory ID])
You can mark that % measure using measure tool
@AtchayaP , Assume you have two measure Employee has skill and Count of active directory ID
Create a new measure
= divide([ Employee has skill],[Count of active directory ID])
You can mark that % measure using measure tool
If I have one columns as skill count how to find percentage
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |