how to calculate percentage

[Anonymous]

Hi All,

I need to calculate percenatge measure, same year i have Y & N and survey count.

Ex: Take FYweek as 202115 ==> if Flag = "N" then 67/(52+67)

                                                    if Flag = "Y" then 52(67+52)

regrad,

Navin_512

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Create following calculated columns:

FyWeekSurveyCount = CALCULATE(SUM(FYSurvey[Survey Count]), FILTER(ALLSELECTED(FYSurvey), FYSurvey[FY Week] = EARLIER(FYSurvey[FY Week])))

FYWeekFlagSurveyCount = CALCULATE(SUM(FYSurvey[Survey Count]), FILTER(ALLSELECTED(FYSurvey), FYSurvey[FY Week] = EARLIER(FYSurvey[FY Week]) && FYSurvey[Flag] = EARLIER(FYSurvey[Flag])))

Then create a measure:

proportion = DIVIDE(SUM(FYSurvey[FYWeekFlagSurveyCount]), SUM(FYSurvey[FyWeekSurveyCount]), 0)

Convert the above measure to PERCENTAGE under Modelling tab.

Then move the following to the table visual, you will get something like below:

Hope this helps.

Thanks,

Pragati

[amitchandak]

@Anonymous , try like

divide(sum(Table[survey count]),calculate(sum(Table[survey count]),allexcept(Table,Table[FY Week]))

[harshnathani · Accepted solution]

Hi @Anonymous ,

Column =

var _sumFY = CALCULATE(SUM('Table'[Survery Count]),ALLEXCEPT('Table','Table'[FY Week]))

var _a = DIVIDE('Table'[Survery Count],_sumFY)

RETURN

_a

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Pragati11 · Accepted solution]

Hi @Anonymous ,

Create following calculated columns:

FyWeekSurveyCount = CALCULATE(SUM(FYSurvey[Survey Count]), FILTER(ALLSELECTED(FYSurvey), FYSurvey[FY Week] = EARLIER(FYSurvey[FY Week])))

FYWeekFlagSurveyCount = CALCULATE(SUM(FYSurvey[Survey Count]), FILTER(ALLSELECTED(FYSurvey), FYSurvey[FY Week] = EARLIER(FYSurvey[FY Week]) && FYSurvey[Flag] = EARLIER(FYSurvey[Flag])))

Then create a measure:

proportion = DIVIDE(SUM(FYSurvey[FYWeekFlagSurveyCount]), SUM(FYSurvey[FyWeekSurveyCount]), 0)

Convert the above measure to PERCENTAGE under Modelling tab.

Then move the following to the table visual, you will get something like below:

Hope this helps.

Thanks,

Pragati