Forum Discussion

cpatterson's avatar
cpatterson
Helper I
7 years ago

How to COUNTIF within a specified date range

Hi again,   I'm trying to use the Gauge visual to demonstrate target completion vs actual completion based on enrollment dates. I think I need a measure to calculate how many values are in a column...
Need Help
Tutorial Requests
MFelix's avatar
MFelix
Super User
7 years ago

Hi cpatterson 

 

Try the following measure:

 

Count plans out =
CALCULATE (
    COUNT ( 'Subscription Plans'[Learning Plan Name] );
    'Subscription Plans'[Completion] = "";
    FILTER (
        ALL (
            'Subscription Plans'[Subscription Date];
            'Subscription Plans'[Learning Plan Name]
        );
        'Subscription Plans'[Subscription Date]
            <= EDATE (
                TODAY ();
                IF ( 'Subscription Plans'[Learning Plan Name] = "Gold Reel"; -6; -12 )
            )
    )
)

Replace the column names by your model information and in the Gold Reel replace it by the plan that as only 6 months, in my example I call it Gold Reel to test out.

 

Regards,

MFelix

  • cpatterson's avatar
    cpatterson
    Helper I
    7 years ago

    Hi MFelix ,

    Thank you for your help! Sorry for the delay in responding to this... I created the measure but when I add it to the visual (or any visual), it says "Can't display the visual."

     

    Do you have an idea on what could be causing this?