Forum Discussion

rellis's avatar
rellis
New Member
4 years ago
Solved

Calculating Donor/Customer Downgrades

Hi All,   Beginner here! I've just started using PBI in the last few months with success but I've gotten stuck trying to build a donor/customer upgrade, downgrade, or held report. So far I've worke...
Need Help
  • v-luwang-msft's avatar
    v-luwang-msft
    4 years ago

    hI rellis ,

    Pls taste the below:

    Downgrades =
IF (
    Gift[Total Giving Diff YOY] < 0,
    CALCULATE (
        DISTINCTCOUNT ( Gift[Constituent_id] ),
        FILTER ( ALL ( Gift ), Gift[Total Giving Diff YOY] < 0 )
    ),
    BLANK ()
)

     

    Did I answer your question? Mark my post as a solution!


    Best Regards

    Lucien

vanessafvg's avatar
vanessafvg
Icon for Community Champion rankCommunity Champion
4 years ago

 

change to insert your code

Downgrade =
VAR giving = [Difference]
RETURN
    IF (
        giving < 0,
        IF (
            ISBLANK ( SUM ( Test[TY] ) ),
            DISTINCTCOUNT ( Test[id] ),
            DISTINCTCOUNT ( Test[id] )
        ),
        0
    )