Filter a dax measure by a text value

[BuistJF]

I have a measure that I'm already using that provide me with the expected results, see DAX below:

Measure 1 = sum(Conversion[Converted]) / sum(Conversion[Count])

I want to re-created the same measure as above but for it to only include records where the column 'fruit' = apples, ie.

Measure 2 = (sum(Conversion[Converted]) / sum(Conversion[Count])) where fruit = "apples"

The column 'fruit' sits in the same table and every row has an allocaited fruit.

I need the filter to apply in the dax measure as I'll want the 2 measures sitting in a line chart. 

[Analystmate]

@BuistJF Measure 2 = CALCULATE(sum(Conversion[Converted]) / sum(Conversion[Count]),Conversion[Fruit ]="apples")

[mariussve1]

hi,

Please try:

Var Converted = sum(Conversion[Converted])

Var Fruit = Calculate ( sum(Conversion[Count]), table[column] = "fruit" )

Var Resultat = Divide(Converted, Fruit, 0)

Return

Result

Br

Marius

[Greg_Deckler · Accepted solution]

@BuistJF Try:

Measure = 
  DIVIDE(
    SUMX(FILTER('Conversion',[fruit] = "apples"),[Converted]),
    SUMX(FILTER('Conversion',[fruit] = "apples"),[Count])
  )