Forum Discussion

BuistJF's avatar
BuistJF
Icon for Helper I rankHelper I
3 years ago
Solved

Filter a dax measure by a text value

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 m...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    BuistJF Try:

    Measure = 
  DIVIDE(
    SUMX(FILTER('Conversion',[fruit] = "apples"),[Converted]),
    SUMX(FILTER('Conversion',[fruit] = "apples"),[Count])
  )
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

BuistJF Try:

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