Dividing data by the number of months selected on a filter

[PowerBINoob12]

I have a table of data that contains metrics for the year

I want to create a measure that will sum all the values in the SLA column and then divide that my the number of months I select when I filter on month.

for example If I filter on Jan, March and Dec I want to add 86.26 + 87.65 + 86.85 and divide that by 3 (number of months selected on my drop down filter).

can anyone explain to me how to do the logic around dividing my the number of months selected in my filter please?

I have a calendar already set up as well if this helps.

[PowerBINoob12]

Thought :

Would creating a column in my calendar that mapped the number 1 beside each month help?

example:

Sum(SLA) / (Countrows("MonthEquals1")

where the "monthEquals1" filter adds one for each month selected?

[Ashish_Mathur]

Hi,

Does this measure work

Measure = DIVIDE(SUM(Table[SLA]),COUNTROWS(ALLSELECTED(Table[Month])))

[Anonymous · Accepted solution]

Hi @PowerBINoob12,

You can consider to use ALLSELECTED function to package and apply current filter effect to the Dax expression:

formula =
CALCULATE (
    DIVIDE ( SUM ( Table[SLA] ), COUNTROWS ( VALUES ( Table[Month] ) ) ),
    ALLSELECTED ( Table )
)

Regards,

Xiaoxin Sheng