how to get the min and max of a page filter to use in a measure

[bsheffer]

I have a filter on date in the filter pane

the only way I seem to be able to remove filters from the filters pane is to use the all(table) command.  I've tried all(column) and allexcept to no avail.  Now I want to do a total count of all rows in a date horizontal barchart with date on the y axis and number of rows on the x axis.  I want to put the total count in the tool tips.

however because it is segmented by date the total count is coming up the same as the count for that date.

if I use calculate(distinctcount(account_number), all(date)) it returns the same number

if I use variables: min(date) and max(date) in the calculate statement, it is giving the same date for that bar of the barchart.  What I really need it seems is to get the min date from the filter and max date from the filter in the filter pane.

Is there a way to do this in dax only?

[v-alq-msft · Accepted solution]

Hi, @bsheffer 

Based on your description, I created data to reproduce your scenraio. The pbix file is attached in the end.

Test:

You may create a measure as below.

Count = 
CALCULATE(
    DISTINCTCOUNT(Test[AccountNumber]),
    ALLSELECTED('Test')
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@bsheffer , Not very clear

Try like

min date = minx(allselected(Date), date)
max date = maxx(allselected(Date), date)

Can you share sample data and sample output in table format?