Forum Discussion

Sulsa's avatar
Sulsa
Frequent Visitor
2 years ago
Solved

Calculation Groups and YTD KPI Goals

Hello All,   I have a calculation group that includes, MTD,LY and YTD. I would like the YTD calculation to show the KPI "Goal" for the whole year, but only show the measure for the dates where ther...
  • Sulsa's avatar
    Sulsa
    2 years ago

    Appreciate your help, but I wasn't able to get that to work. What did though was to use an IF in the measure (and not in the KPI or calculation group) like this:

        IF(
        min( Dates[Valid Period] ) = 0, BLANK(),
        - CALCULATE(
            <some aggragation here>,<some filter here>
                
            )
        )
    )

     

some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
2 years ago

Hi Sulsa search for part "ShowValueForDates " on link as idea and possible solution

Sulsa's avatar
Sulsa
Frequent Visitor
2 years ago

Appreciate your help, but I wasn't able to get that to work. What did though was to use an IF in the measure (and not in the KPI or calculation group) like this:

    IF(
        min( Dates[Valid Period] ) = 0, BLANK(),
        - CALCULATE(
            <some aggragation here>,<some filter here>
                
            )
        )
    )