cancel
Showing results for
Did you mean:
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.

 Month Value x Value Y Total (X+Y) % of value X against total Jan'19 419 1526 1945 27% Feb'19 149 1630 1779 9% Mar'19 145 2036 2181 7%

Thanks and Best Regards,

Srihari.K

1 ACCEPTED SOLUTION

Accepted Solutions
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)``````

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

3 REPLIES 3
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

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

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

 Month Empl ID Ontime/Delayed Jan-19 A Ontime Jan-19 B Delayed Jan-19 C Ontime Jan-19 D Ontime Feb-19 E Ontime Feb-19 F Delayed Feb-19 G Delayed Feb-19 H Ontime Mar-19 I Ontime Mar-19 J Delayed Mar-19 K Delayed Mar-19 L Delayed

Best Regards,

Srihari

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)``````

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

Announcements

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!

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

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