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
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

Hi   binayjethwa 

try to write a measure like this:

Measure =
VAR _count = 
COUNTROWS(
    FILTER(
        ALL(TableName),
        TableName[Weight] = 14
    )
)
RETURN
DIVIDE(_count, 100)