topic Divide a Count column by another Count column per month in DAX Commands and Tips

Divide a Count column by another Count column per month

Lyle — Tue, 21 Dec 2021 10:20:25 GMT

Please help with a formula for a percentage per month. January would be 7 / 136 = 5.15%

Thanks in advance!

amitchandak — Tue, 21 Dec 2021 10:37:28 GMT

Lyle , Try measure like

Divide(Count(Table[LSE]) , Count(Table[Mode]))

Divide(distinctCount(Table[LSE]) , distinctCount(Table[Mode]))

mark it as % measure from measure tool

Lyle — Tue, 21 Dec 2021 10:48:34 GMT

Thank you sir