Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Totaling Multiple Filtered Measures

Hello,   I am putting together a type of weighted caseload for my staff members. It is kind of complex and i am wondering if anyone has any ideas or better ways to go about this or even a dax comma...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

     

    Please check the measure below.

    Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[case] ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -12 ) )
) * 20
    + CALCULATE (
        DISTINCTCOUNT ( 'Table'[case] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -60 ) )
    ) * 5

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

Please check the measure below.

Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[case] ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -12 ) )
) * 20
    + CALCULATE (
        DISTINCTCOUNT ( 'Table'[case] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -60 ) )
    ) * 5

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you so much!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have one more question  as well using the below dax statement. I want to add another total to this but i want to filter by a specific value name in a column instead of date. What would that entail?

     

    Measure =
CALCULATE (
    DISTINCTCOUNT ( 'Table'[case] ),
    FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -12 ) )
) * 20
    + CALCULATE (
        DISTINCTCOUNT ( 'Table'[case] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] >= EDATE ( TODAY (), -60 ) )
    ) * 5

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Is there anyway to get this to add up correctly when you take the individual filter off too? I am finding that it adds quite a bit to the score number when taking the individual filter off by person and looking at everyone as a whole.