cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srihari3
Regular 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)




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


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





Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


Srihari3
Regular 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)




Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin


View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors