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])))

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Seems like ALLEXCEPT('Table'[Renewal Date]) but otherwise the same formula.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Still not working. Can I share my file?