Calculating a Weighted Standard Deviation

Hi amitchandak ,thanks for your quick reply, I will add more.

Hi KDGRF ,

'Total' is calculated after removing the filter conditions.

The Table data is shown below:

The filter condition in the 'Table' visual is the column 'Product'. The result of the total is consistent with the value in the card visual.(There are no filters for either)

Please follow these steps:

1.Use the following DAX expression to create a table

Table 2 = 
VAR _table1 = SUMMARIZE('Table','Table'[Product],
"Count of Strength",COUNT('Table'[Strength]),
"Cal.1",IF( COUNT('Table'[Strength]) > 3,STDEV.P('Table'[Strength]),BLANK()),
"Cal.2",IF(COUNT('Table'[Strength] ) > 3,COUNT('Table'[Strength]),BLANK()))
VAR _table2 = ADDCOLUMNS(_table1,"Cal.3",[Cal.1] * [Cal.2])
RETURN 
_table2

Modify it according to your needs.

2.Use the following DAX expression to create measures.(Use the function 'SELECTEDVALUE' to determine whether the row is 'Total', if so, then 'SELECTEDVALUE' returns null.)

SELECTEDVALUE function - DAX | Microsoft Learn

Count of Strength = 
IF(ISBLANK(SELECTEDVALUE('Table'[Product])),
SUM('Table 2'[Count of Strength]),
COUNT('Table'[Strength]))

Cal.1 = 
IF(ISBLANK(SELECTEDVALUE('Table'[Product])),
SUM('Table 2'[Cal.1]),
IF(COUNT('Table'[Strength]) > 3,STDEV.P('Table'[Strength]),""))

Cal.2 = 
IF(ISBLANK(SELECTEDVALUE('Table'[Product])),
SUM('Table 2'[Cal.2]),
IF(COUNT('Table'[Strength] ) > 3,COUNT('Table'[Strength]),""))

Cal.3 = 
IF(ISBLANK(SELECTEDVALUE('Table'[Product])),
SUM('Table 2'[Cal.3]),
IF([Cal.1] = "","",[Cal.1] * [Cal.2]))

3.Final output

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