Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Count Indicator Achievement [DistinctCount, Summarize, Countrows]

Hi there,  Newbie is here. I have been stuck for 1 month to fix my dashboard. Hope someone can help me. I have a raw data like this: IndicatorName Month Target Actual Indicator1 01/01/20...
COUNTROWS
distinct count
SUMMARIZE
SUMMARIZECOLUMNS
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

    All measures are in the attached pbix file.

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

All measures are in the attached pbix file.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Jihwan_Kim 

    Thanks a lot for your effort. I just clone your DAX to my dataset. Unfortunately, for the 'Indicator Achieved' VAR, it's still counting non targeted indicator if it has 'Actual' value. This is not what I expecting before.

    from above, this supposed to be '7' Indicator Achieved not 9.

     

    Is it because of [HASONEVALUE 'Achievement Measure'] ? Is there any way to adjust from this:

    Achievement measure: =
    IF (
        HASONEVALUE ( Indicator[IndicatorName] ),
        IF (
            [Target measure:] = 0
                && [Actual measure:] <> 0,
            1,
            DIVIDE ( [Actual measure:], [Target measure:] )
        )
    )
     
    Thanks again for your helpful hands.