cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Srihari3 Frequent Visitor
Frequent Visitor

How to calculate % on monthl totals in measure

Hi All,

 

Need a help on how to define the measure for arriving at the % of monthly . Below is example my table.

 

MonthValue xValue YTotal (X+Y)% of value X against total
Jan'194191526194527%
Feb'19149163017799%
Mar'19145203621817%

Thanks and Best Regards,

Srihari.K

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: How to calculate % on monthl totals in measure

Try like

 

ontime = calculate(countrows(table),Ontime/Delayed="Ontime")

total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])

% =divide(ontime,total)

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: How to calculate % on monthl totals in measure

Try like

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-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

Srihari3 Frequent Visitor
Frequent Visitor

Re: How to calculate % on monthl totals in measure

Dear Amit,

 

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

 

MonthEmpl IDOntime/Delayed
Jan-19AOntime
Jan-19BDelayed
Jan-19COntime
Jan-19DOntime
Feb-19EOntime
Feb-19FDelayed
Feb-19GDelayed
Feb-19HOntime
Mar-19IOntime
Mar-19JDelayed
Mar-19KDelayed
Mar-19LDelayed

 

Thanks in advance for your help

 

Best Regards,

Srihari

Super User IV
Super User IV

Re: How to calculate % on monthl totals in measure

Try like

 

ontime = calculate(countrows(table),Ontime/Delayed="Ontime")

total = calculate(count(table[Empl ID]),ALLEXCEPT(table[Month])

% =divide(ontime,total)

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors