AllSelected

Question

Hello Community -&nbsp; I am not sure if AllSelected is the key to my issue, but I think maybe so....just not sure how to implement it.&nbsp;&nbsp;&nbsp;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.&nbsp; &nbsp; If I deselct the row, or remove the filter from the filter pane, then it shows me the total count again.&nbsp; &nbsp; 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.&nbsp; &nbsp; &nbsp;Below is the formula for the card visual&nbsp; (distinct AR shipments).&nbsp;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&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

parry2k · Accepted Answer

Anonymous&nbsp;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
&nbsp;
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

&nbsp;
&nbsp;

Forum Discussion

AllSelected

2 Replies

Related content

Optimize AllSelected

Allselected function

ALLSELECTED vs VALUES

RANKX with ALLSELECTED

SELECTEDVALUE, ALL, ALLSELECTED