Forum Discussion

chestercas's avatar
chestercas
Icon for Helper I rankHelper I
3 years ago

Distinct Count with true/false

Hi,   I have a table with custumer and a percent value. I want to calculate the number of custumer who is under 50%. My goal is to create a card graph, with this total. I tried many measure (coun...
Need Help
mlsx4's avatar
mlsx4
Icon for Memorable Member rankMemorable Member
3 years ago

Have you tried with:

 

bour= 
COUNTROWS(
  SUMMARIZE(
    FILTER(DATA_BRMC,_txfac>0.5),
    DATA_BRMC[Nom prénom CC]
  )
chestercas's avatar
chestercas
Icon for Helper I rankHelper I
3 years ago

Hi,

Thanks for your help ! it doesn't work. I have empty result to. 😞