Calculate Average / Sum of other rows based on slicer selection

[User232431]

Hi Need help on getting average of values for some other rows,

Ex: If user select value from name column with in those slicers then card should show average of other rows base on same slicers

If user select Name - "A" with nsome slicers the in card value should be average of value for the same slicers, In my below example showing average of all values (13) irrespective of slicers instead of 10.

The measure that i wrote is as below:

_newmeasure =

VAR _dpv = SELECTEDVALUE(Actual[Name])

RETURN

SWITCH(

    TRUE(),

    _dpv = "A", "B Value" & ": " &  CALCULATE(AVERAGE(Actual[Values]),FILTER(all(Actual),Actual[Name]="B")),

    _dpv = "E", "F Value" & ": " &  CALCULATE(AVERAGE(Actual[Values]),FILTER(all(Actual),Actual[Name]="F")),

    "* No data"

)  

Request any modification in above measure. Thanks in advance

[v-pnaroju-msft]

Hi @User232431,

We are happy to learn that your issue has been resolved. To help others in the community, kindly mark the response that resolved your query as the accepted solution.

For any further assistance or questions, please continue to engage with the Fabric Community.

Best regards,
Pavan

[User232431 · Accepted solution]

I have solved using below DAX

_newmeasure =

VAR _dpv = SELECTEDVALUE(Actual[Name])

VAR _et = SELECTEDVALUE(Actual[Country])

VAR _pt = SELECTEDVALUE(Actual[Period])

var _yr = SELECTEDVALUE(Actual[Year])

var _mn = SELECTEDVALUE(Actual[Month])

//VAR _en = SELECTEDVALUE(Actual[Name])

RETURN

SWITCH(

    TRUE(),

   // _dpv = "A", "B Value" & ": " & IF( (ISFILTERED(Actual[Country])||ISFILTERED(Actual[Period])||ISFILTERED(Actual[Year])||ISFILTERED(Actual[Month])), CALCULATE(AVERAGE(Actual[Values]),FILTER((Actual),Actual[Name]="B"))),

   _dpv = "A", "B Value" & ": " & CALCULATE(AVERAGE(Actual[Values]),FILTER(all(Actual),(Actual[Name]="B")

    && Actual[Country] = _et && Actual[Period] =_pt && Actual[Year] =_yr && Actual[Month] = _mn  )),

    _dpv = "E", "F Value" & ": " &  CALCULATE(AVERAGE(Actual[Values]),FILTER(all(Actual),(Actual[Name]="F")

    && Actual[Country] = _et && Actual[Period] =_pt && Actual[Year] =_yr && Actual[Month] = _mn   )),

    "* No data"

)

Thank you

[v-pnaroju-msft]

Hi @User232431,

We are delighted to know that your issue has been resolved. Kindly mark the response that resolved your query as the accepted solution. This will assist other community members facing similar challenges in finding solutions more efficiently.

Please continue to utilise the Fabric Community for any further assistance with your queries.

Best regards,
Pavan