The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
i have table name called PO compliance
Thats table have three column
Month PO
May Within
May Within
May oVer
May Within
June Within
June Within
June oVer
June Within
July Within
July Within
July oVer
July Within
@amitchandak i have month wise count PO values. now i have only three months may,june,july. i want percentatge month wise not a over all ..
@Anonymous , Your current table at last is
divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month])))
Can you share the expected output.
If you need June, July together , you need a new column
Month1 = if([Month] ="May", "May", "Other")
divide(count(Table[PO]), calculate(count(Table[PO]), allexcept(Table, Table[Month1])))
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
11 | |
7 |