Percentage not Correctly Showing when filtered by country

[swaggerboy69]

Hello Team,

This is with regards to the topic - https://community.powerbi.com/t5/Desktop/Calculate-Monthly-Growth-that-would-respond-to-slicers-for/...

It worked before but after a month when I try to filter by country, it doesn't show correct values anymore.

See below if not filtered:

When filtered by a specific country:

See code being used below:

==============================================================================

Call Count PM =
VAR CurrentYearMonth = SELECTEDVALUE('Return to Office'[YearMonthNum])
VAR PreviousYearMonth =
CALCULATE(
MAX('Return to Office'[YearMonthNum]),
ALLSELECTED('Return to Office'),
KEEPFILTERS('Return to Office'[YearMonthNum] < CurrentYearMonth)
)
VAR Result =
CALCULATE(
[Internal Call Count No Blank],
'Return to Office'[YearMonthNum] = PreviousYearMonth,
REMOVEFILTERS('Return to Office')
)
RETURN
Result

==============================================================================

Call Count Diff PM =
VAR CallCountCurrentMonth = [Internal Call Count No Blank]
VAR CallCountPrevMonth = [Call Count PM]
VAR Result =
DIVIDE(
CallCountCurrentMonth - CallCountPrevMonth,
(NOT ISBLANK (CallCountCurrentMonth))*(NOT ISBLANK (CallCountPrevMonth))
)
RETURN
Result

==============================================================================

% Call Count Monthly Growth =
DIVIDE(
[Call Count Diff PM],
[Call Count PM]
)

==============================================================================

Let me know what I'm doing wrong.

[swaggerboy69 · Accepted solution]

I resolved the issue.

I added ALL ( 'Date' )

Then removed REMOVEFILTERS

[tamerj1]

@swaggerboy69 

Advise you to have a date table. Code will be more simple and more efficient. 

[swaggerboy69]

Any code/logic suggestions?

[tamerj1]

@swaggerboy69 

Almost the same code that you are using now. Just there is no need to use ALLSELECTED as the date will be filtered using a separate table. Please provide more details about your data and its granularity then might be able to help you further

[swaggerboy69]

ok. so my data is counting call counts from a video conferencing device per month.

so i need to be able to see growth rate of calls per month.

it shows the correct percentage if not filtered by country. 

the issue shows up when i filter by country or city or office location.

[v-shex-msft]

Hi @swaggerboy69,

According to your description, it sounds like multiple aggregates calculate issues on DAX formulas.
For this scenario, you can try to add a variable with summarizing function to group the calculated result based on current category fields. Then you can use the iterator function sumx to apply the second aggregate to summary previous results:

Measure Totals, The Final Word 
Regards,

Xiaoxin Sheng