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.
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])))