AllSelected

[Anonymous]

Hello Community -  I am not sure if AllSelected is the key to my issue, but I think maybe so....just not sure how to implement it.  

What is happening, is that when I either filter on an Order number...or if I select a row in the table below, instead of showing me the count in the card visual, it just says 0.    If I deselct the row, or remove the filter from the filter pane, then it shows me the total count again.    The behavior that I am expecting is that if I select one or more rows, the card visual on the right will show me how many orders I have selected based on the distinct order number.     Below is the formula for the card visual  (distinct AR shipments).

AR Distinct Order # Count = CALCULATE(DISTINCTCOUNT('Flu Shipped'[Order]),FILTER(DateTable,DateTable[Weekend or Weekday]="Weekday"),FILTER('Flu Shipped','Flu Shipped'[DateShipped]),FILTER('Flu Shipped','Flu Shipped'[AR] = True ))+0

[Icey]

Hi @Anonymous ,

Does @parry2k solve your problem?

If he does, please accept his reply as a solution so that people who may have the same question can get the solution directly.

If not, please share us more details.

Best Regards,

Icey

[parry2k · Accepted solution]

@Anonymous not sure how your data model looks like and why you have filter conditions in there, why no go to basics first and then go from there, so add a measure like below and see if you can see the numbers when you select a row or value in the slicer

New Measure = DISTINCTCOUNT ( 'Flu Shipped'[Order] ) + 0

and with filters

New Measure =
CALCULATE (  
DISTINCTCOUNT ( 'Flu Shipped'[Order] ),
DateTable[weekend or weekday] = "Weekday",
'Flu Shipper'[AR] = TRUE
) + 0