Forum Discussion

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    SabineOussi,

     

    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

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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

SabineOussi's avatar
SabineOussi
Skilled Sharer
10 years ago

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.