Calculate total rows based on slicer selection

Question

Hi All,&nbsp;&nbsp;I have the following table where I have list of&nbsp; 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&nbsp;BLs/subsidiaries , so my count should change bsed on&nbsp;BLs/subsidiaries slicer selection for example for below&nbsp;&nbsp;BLs/subsidiaries as "One" I have total row count as 14 , if i change slicer to another selection my row count also changes.Can someone help here.Thanks.&nbsp;&nbsp;&nbsp;weight =100/14&nbsp;&nbsp;&nbsp;Total row count =14&nbsp;&nbsp;&nbsp;ItemSourceBLs/subsidiariesWeightAsset&nbsp;InitiativesOne7.142857Overall&nbsp;BLOne7.142857Energy&nbsp;BLOne7.142857Availability&nbsp;BLOne7.142857RE&nbsp;InitiativesOne7.142857&nbsp;EmissionsBLOne7.142857ConversionInitiativesOne7.142857Fuel&nbsp;&nbsp;BLOne7.142857Energy&nbsp;&nbsp;BLOne7.142857Reliability&nbsp;InitiativesOne7.1428573E’sInitiativesOne7.142857Reliability&nbsp;InitiativesOne7.142857Thermal&nbsp;BLOne7.142857Reliability&nbsp;InitiativesOne7.142857

freemanz · Answer

Hi&nbsp;&nbsp;&nbsp;binayjethwa&nbsp;try to write a measure like this:Measure =VAR _count =&nbsp;COUNTROWS(&nbsp; &nbsp; FILTER(&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; ALL(TableName),&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &nbsp;TableName[Weight] = 14&nbsp;&nbsp; &nbsp;))RETURNDIVIDE(_count, 100)

binayjethwa · Answer

FreemanZ&nbsp; here count of weight =14 is just given for reference, it will change based on slicer selection and its&nbsp; dynamic. In above table there are 14 rows hence count is 14 , if there are 4 rows i should see&nbsp; weight as 25% for each row.

freemanz · Answer

Hi&nbsp;binayjethwa&nbsp;&nbsp;Not sure if i fully get you, then try&nbsp;Measure =
VAR _bl =SELECTEDVALUE(TableName[ BLs/subsidiaries])
VAR _count = 
COUNTROWS(
    FILTER(
        ALL(TableName),
        TableName[BLs/subsidiaries] = _bl
    )
)
RETURN
DVIDE(100, _count)

binayjethwa · Answer

FreemanZ&nbsp; 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 · Answer

hi&nbsp;binayjethwa&nbsp;try like:Measure = VAR _count = COUNTROWS(TableName)RETURN DIVIDE(100, _count)&nbsp;it worked like this:&nbsp;if it doesn't work, please consider expand your data sample to fully represent the issue and expectation. And continue&nbsp;@me, if furthere suggest is needed.&nbsp;

Forum Discussion

Calculate total rows based on slicer selection

8 Replies

Related content

Selected slicer

Slicer default selection

Single select slicer

Between date slicer - calender selection

Quarter calculation upto selected month

weight =100/14
Total row count =14
Item	Source	BLs/subsidiaries	Weight
Asset	Initiatives	One	7.142857
Overall	BL	One	7.142857
Energy	BL	One	7.142857
Availability	BL	One	7.142857
RE	Initiatives	One	7.142857
Emissions	BL	One	7.142857
Conversion	Initiatives	One	7.142857
Fuel	BL	One	7.142857
Energy	BL	One	7.142857
Reliability	Initiatives	One	7.142857
3E’s	Initiatives	One	7.142857
Reliability	Initiatives	One	7.142857
Thermal	BL	One	7.142857
Reliability	Initiatives	One	7.142857