Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Please help with a formula for a percentage per month. January would be 7 / 136 = 5.15%
Thanks in advance!
Solved! Go to Solution.
@Lyle , Try measure like
Divide(Count(Table[LSE]) , Count(Table[Mode]))
or
Divide(distinctCount(Table[LSE]) , distinctCount(Table[Mode]))
mark it as % measure from measure tool
Thank you sir
@Lyle , Try measure like
Divide(Count(Table[LSE]) , Count(Table[Mode]))
or
Divide(distinctCount(Table[LSE]) , distinctCount(Table[Mode]))
mark it as % measure from measure tool
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 13 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 10 | |
| 10 | |
| 6 | |
| 6 |