Forum Discussion

geivaz0606's avatar
geivaz0606
Regular Visitor
4 years ago
Solved

Division Measure with special case

Good Day, I hope someone can help me with this request.  It seems like a simple problem but I am stumped as to how to handle this.   I have a simple dataset.  It looks something like this.   ...
DAX
measure
Switch()
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    It's not clear to me what the desired result should be in such a case. Are you trying to calculate an average iterating over the rows of the fact table?

     

    If so, just stick it inside an AVERAGEX.

    Preferred Method =
AVERAGEX (
    'Fact',
    SWITCH (
        'Fact'[Risk Status],
        "On-Risk", [Progress Measure],
        "Inactive", 0,
        "Off-Risk", 1
    )
)
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

This is fairly straightforward with a SWITCH.

Preferred Method =
SWITCH (
    SELECTEDVALUE ( 'Fact'[Risk Status] ),
    "On-Risk", [Progress Measure],
    "Inactive", 0,
    "Off-Risk", 1
)

 

geivaz0606's avatar
geivaz0606
Regular Visitor
4 years ago

Alexis, Thank you for the response.  You are correct in that your response works for the problem I described.  However, in my in-experience, I did not describe the problem very well.  

Good Response

 

My problem is that I did think about what would happen when this Measure gets used in other areas.  For example, when we look at the full dataset, there is also a year. And if we group by that in a Matrix, we don't get the desired result.

 

Would you happen to know how that could be solved, please?

Btw, if you want, I will mark your previous answer as "Accept as Solution" if you so desire.

 

Thank you in advance.

George

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    It's not clear to me what the desired result should be in such a case. Are you trying to calculate an average iterating over the rows of the fact table?

     

    If so, just stick it inside an AVERAGEX.

    Preferred Method =
AVERAGEX (
    'Fact',
    SWITCH (
        'Fact'[Risk Status],
        "On-Risk", [Progress Measure],
        "Inactive", 0,
        "Off-Risk", 1
    )
)