Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Count only related/selected values

Hi I have following data.   Table Sheet1:   Consumer_Name Consumer_Column Immidiate_Source Immidiate_Column New Ultimate Source System Ultimate Source Column DW_AVAIL DRDC Term1 Imm...
Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous 

    You may create a measure like below:

    Count =
CALCULATE (
    COUNT ( Sheet2[Immidiate_Column] ),
    FILTER ( Sheet1, Sheet1[DW_AVAIL] = "N" )
)

    Regards,

    Cherie

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

You may create a measure like below:

Count =
CALCULATE (
    COUNT ( Sheet2[Immidiate_Column] ),
    FILTER ( Sheet1, Sheet1[DW_AVAIL] = "N" )
)

Regards,

Cherie