Forum Discussion
Total Count with Selection
Hello,
I'm trying to create a table of customers, their total shipment count and an additional column to show the count of how many shipments were made with a certain priority. Priority is being filtered by a sclicer.
In my selection, I want to always keep the total count of all customers and only the third column changes based on the shipment type.
I tried having a calculated column with an IF condition on the priority or even adding the priority to the visual level filter. But this will change the values of both totals.
How can I achieve this?
Thanks.
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
6 Replies
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.
