Forum Discussion

binayjethwa's avatar
binayjethwa
Helper V
3 years ago

Calculate total rows based on slicer selection

Hi All,    I have the following table where I have list of  Item. To calculate weight , i need to count rows of table which is 14 and divide it by 100 as mentioned below. Also I have a slicer for...
Need Help
v-zhangti's avatar
v-zhangti
Community Support
3 years ago

Hi, binayjethwa 

 

You can try the following methods.

Measure = 
Var _N1= CALCULATE(COUNT('Table'[BLs/subsidiaries]),ALLEXCEPT('Table','Table'[BLs/subsidiaries]))
Return
DIVIDE(100,_N1)

Two is four rows.

Is this the result you expect?

 

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.

 

binayjethwa's avatar
binayjethwa
Helper V
3 years ago

Hi v-zhangti  i still see same result. can u please check.

 

  • v-zhangti's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, binayjethwa 

     

    Based on the screenshots you provided, what do you expect the result to be?

     

    Best Regards,

    Community Support Team _Charlotte