Removing blank option in slicer but including blanks - Also 2 slicers affecting one measure

[keranjit]

I have a table full of collections - including if it was late or ontime, who collected, coll ID, date collected, the late reason etc

Ideally I want to do a Count of the number of deliveries using 2 slicers - Date and Late reason + Blanks

(This measure will be used to calculating performance per carrier)

E.g User can select Month and then select Late reason and must have (Blank) selected at all times

The collection count is then show in a table - split by carrier

The tricky bit is I don't want the user to see the option (Blank) in the slicer.

I've tried a page filter to remove blanks and add them on in my measure.

Coll = COUNTROWS(sheet3) + CALCULATE(COUNTROWS(Sheet3),ALLEXCEPT(Sheet3,Sheet3[Carrier name],Sheet3[Date]),Sheet3[MAIN REASON]="")

(The first part counts the lates selected, The second part counts the blanks)

When using the date and late reason slicers, the late reasons slicer reduces the date range which in turn affects the second part of the Collection count measure.

The easier the solution the better please and I'm still a beginner in using DAX.

[v-yuezhe-msft]

@keranjit,

Check if the following DAX returns your expected result.

Coll = CALCULATE(COUNTROWS(Sheet3),FILTER(ALL(Sheet3), Sheet3[MAIN REASON]=BLANK()))+COUNTROWS(Sheet3)

Regards,