Forum Discussion
Total Count with Selection
I could found a workaround for your issue, It's not pretty nice looking, but I guess it works :)
I assume that you have a reference table with your customers stored in.
I've created a new column based on a formula :
The formula count the number of ship (here it's a sum because I didn't create all the record),
And now, when you used if you don't select any flag type, both of the columns are the same :
But as soon as you select a flag type, the "ship by customer" column stay the same when the other column is updated :
Hope it help you
Sébastien
Hello SabineOussi
You should try the following formula in order to get your count without impacted by the selection
MyCount = CALCULATE(DISTINCTCOUNT('Requête1'[id]);filter(ALL('Requête1');true()))
Hope it helps
Sébastien
Hi Sebastien,
It worked as a calculated measure, however it's giving me the overall total while I want the total by customer.
I tried countx but it did not work.
Ok, could you just show us the data, and whitch one you want to be filtered by the slicer, and whitch one not?
Sebastien
Here is the data in Excel.
Shipment represents the number of shipments made.Let's assume Flag is the value being filtered so it's in a slicer. For the sake of simplicity, it contains two value: T/F.
If T is selected, it will show the data as is, counting how many of these shipments were considered as flagged (or in my case with a certain priority I will later choose).
Your calculated field gave me the total number of shipments for all customers and the regular count worked fine for each selection. What I want is the count of each customer to still count the total and another column to count the total when filtered,Any workaround?
