Forum Discussion

novotnajk's avatar
novotnajk
Resolver I
4 years ago
Solved

Aggregate Patient Claims when Exceeding Threshold

Hi PBI Gurus!  Need some help.  Here's my dilemma:   Part 1 - Table Here is my data table example Special ID          reporting_date           $ Medical Spend ABC123              1/1/2021       ...
Need Help
Tips and Tricks
  • novotnajk's avatar
    novotnajk
    4 years ago

    Hi Nathaniel!

     

    We fixed all but one of the problems!  🙂  I'm going to repost the outstanding issue.  Thanks for your help!

Nathaniel_C's avatar
Nathaniel_C
Community Champion
4 years ago

Hi novotnajk 
Try this. And I resaved my .pbix, so try clicking on the link again.

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Per user =
VAR _specialID =
    MAX ( '$ Medical Spend'[Special ID       ] )
VAR _calc =
    CALCULATE (
        [Running Total - ISL],
        FILTER (
            ALL ( '$ Medical Spend'[Special ID       ] ),
            '$ Medical Spend'[Special ID       ] = _specialID
        )
    )
RETURN
    IF ( _calc > 0, _calc, 0 )