Forum Discussion

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
4 years ago
Solved

Grand total Percentage dynamically

Hi All, I need to calculate the percentage of Total. If no filter is applied it should calculate based on grand total. If i apply any filter say country, manager name then it should take the total b...
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, unnijoy 

     

    Please check the following methods.

    Measure = 
Var _name=SELECTEDVALUE('Table'[Leader name])
Var _CountEmpid=CALCULATE(COUNT('Table'[Empid]), FILTER(ALL('Table'),MONTH('Table'[Month])=1))
Var _Countname=CALCULATE(COUNT('Table'[Leader name]),FILTER(ALL('Table'),MONTH('Table'[Month])=1&&[Leader name]=_name))
Return
IF(_name=BLANK(),_CountEmpid,DIVIDE(_Countname,_CountEmpid))

    If the method I provided above can't solve your problem, what's your expected result? Could you please provide more details for it?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

unnijoy , Not able to get that 3/4 logic. can you explain

 

you can try a measure like

 

divide(calculate(count(Table[Empid]), allselected()) ,

calculate(count(Table[Empid]), all()) )

unnijoy's avatar
unnijoy
Icon for Post Prodigy rankPost Prodigy
4 years ago

Hi amitchandak ,

 

thanks for the qucik response. A small change its 3/5

3 = total count of Jack for January. 

5 = overll total empid count.

i use the formula that u gave but when i put the measure in a bar graph it is taking the overall count of the selected manager. what we need is the overall total. so as ber the above example it should be 3/5...

how can we achive this.

  • unnijoy's avatar
    unnijoy
    Icon for Post Prodigy rankPost Prodigy
    4 years ago

    hi amitchandak ,

     

    can you please help me with the above request.