Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUser | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |