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

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

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

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

Announcements