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.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Jihwan_Kim . I have managed the rest. Just to add conditional in countrows part and it works. 

 

Indicator Achieved NEW = COUNTROWS ( FILTER ( Indicator, [Achievement measure] >= 0.9 && [SUM Target NEW]<>0) )

 

You've saved my day! Thank you