Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help - ALL function not filtering accurately

Hi,   My problem is the PLAN COUNT in the CARD visual. When I filter for a FLEXIPLAN_NAME, my goal is for the PLAN COUNT not to change. I used below formula for the PLAN COUNT:   Plan Count = CA...
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Perhaps try:

    COUNTROWS(DISTINCT(ALL('b2b_datalab_cvm_pp_result JJ_Mobility_Trading_Ranges'[FLEXIPLAN_NAME])))

     

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, Anonymous 

 

Is your problem been solved? Can you share a sample fake data file? There is no problem with your formula, and it’s a bit difficult to modify if I don’t know the specific context.

 

Best Regards

Janey Guo

 

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I found a way to solve this by creating a separate table. Thank you very much for your help Greg_Deckler