Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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:
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
Solved! Go to Solution.
@Anonymous Perhaps try:
COUNTROWS(DISTINCT(ALL('b2b_datalab_cvm_pp_result JJ_Mobility_Trading_Ranges'[FLEXIPLAN_NAME])))
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
I found a way to solve this by creating a separate table. Thank you very much for your help @Greg_Deckler
@Anonymous Perhaps try:
COUNTROWS(DISTINCT(ALL('b2b_datalab_cvm_pp_result JJ_Mobility_Trading_Ranges'[FLEXIPLAN_NAME])))
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
Seems like ALLEXCEPT('Table'[Renewal Date]) but otherwise the same formula.
Still not working. Can I share my file?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |