Forum Discussion

binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper 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
binayjethwa's avatar
binayjethwa
Icon for Helper V rankHelper V
3 years ago

FreemanZ  The above measure is working fine with single selection , but if i do multiple selections i see weight is calculated sepatately. even if i do multiple selections , for example 2 BL/subsidaries , it should take total count of selected BL/s and divide by 100 as a whole. can you please suggest how we can achieve this.

FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi binayjethwa 

try like:

Measure =
VAR _count = COUNTROWS(TableName)
RETURN DIVIDE(100, _count)
 
it worked like this:

 

if it doesn't work, please consider expand your data sample to fully represent the issue and expectation. And continue @me, if furthere suggest is needed.