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 = CALCULATE(DISTINCTCOUNT('b2b_datalab_cvm_pp_result JJ_Mobility_Trading_Ranges'[FLEXIPLAN_NAME]), ALL('b2b_datalab_cvm_pp_result JJ_Mobility_Trading_Ranges'[FLEXIPLAN_NAME]))
 
When I filter for last 12 month renewal date, I have a total plan count of 337. However, when I start selecting for a plan name, the 337 changes BUT IT SHOULD NOT.
 
No Filter Plan Name Result (Plan Count = 337)
 

 

With Filter Plan Name (Plan Count = 75): 

 


 

The goal is to make that 337 a constant when I change PLAN NAMES. The only time that 337 changes is when I change the filter for the renewal date which I didnt include in the formula. 

 

Best,

John Jason

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

     

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    5 years ago

    Anonymous Perhaps try:

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      I still have issue:

       

      Yes 421 is already constant but I should be getting 337 becuase of the renewal date filter and that 337 should not move unless I change renewal date. The only time that plan count should be changing is when I change renewal date and not when I change selection for Flexiplan Names

       

       

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        5 years ago

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

  • 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