Need a help on how to define the measure for arriving at the % of monthly . Below is example my table.
Thanks and Best Regards,
Go to Solution.
ontime = calculate(countrows(table),Ontime/Delayed="Ontime")
total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])
View solution in original post
measure = divide(sum(Table[Value x]),sum(Table[Total X+ Y]))*100
measure = divide(sum(Table[Value x]),sumx(Table,Table[Value x]+Table[Value Y]))*100
* 100 is optional if you plan to show it as %.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks. My Recent Blog -Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin
Thanks for your quick solution. I have posted the table wrongly. In this case both X & Y are in the same column
Below is my raw data - where i need to have Month wise % of Ontime reportees & Delayed reportees
Ex: Jan-19 : 75% ontime & 25% delayed
Thanks in advance for your help
Join us in the third Triple A event!
It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.
Make sure you didn't miss any of the things that happened in the community in January!