Help - ALL function not filtering accurately

[Anonymous]

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

[v-janeyg-msft]

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]

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

[Greg_Deckler · Accepted solution]

@Anonymous Perhaps try:

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

[Anonymous]

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]

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

[Anonymous]

Still not working. Can I share my file?