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.