Forum Discussion

Boycie92's avatar
Boycie92
Resolver I
8 years ago
Solved

DAX help - when filtering reports

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

Need Help
Show and Tell
  • MFelix's avatar
    MFelix
    8 years ago

    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

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    8 years ago

    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