DAX help - when filtering reports

[Boycie92]

Hi,

I’m wondering if someone can help.

I have the following Measures:

No of Sales = CALCULATE(COUNTROWS(Sales),Sales[Time Period] = "<= 28 days")

No of Records = COUNTROWS(Sales)

% = DIVIDE([No of Sales],CALCULATE([No of Records],ALL(Sales)),0)

The % measure works perfect at the high level when I don’t have any filters applied.

However When I apply a filter (MonthYear) the calculation will show me the “correct” result because it will show me a percentage based on all records across all Dates.

However I would like that % to be calculated based on my filter selection. So if I filtered the report using April 2017 the measures will only look at the rows within that date range and calculate the percentage.

Can anyone advise me on how to achieve this?

Thanks in advance,

Boycie92

[MFelix · Accepted solution]

Hi @Boycie92,

When you are calculating the overall percentage you have overlaping the filters in the context and choosing all of the data, that is why your overall calculations are differente because you are calculating the month values over all sales you need to use ALLSELECTED.

% = DIVIDE([No of Sales],CALCULATE([No of Records],ALLSELECTED(Sales)),0)

Regards,

MFelix

[Boycie92]

It works!

Thanks @MFelix