Forum Discussion

tvm_analyst's avatar
tvm_analyst
Frequent Visitor
6 years ago
Solved

Static KPI target

I have this measure that shows the % of Windows systems that have critical vulnerabilities patched within 30 days.   windows_asset_goal = var MEASURE_VALUE = CALCULATE(DISTINCTCOUNT('public fact...
Need Help
  • tvm_analyst's avatar
    tvm_analyst
    6 years ago

    Thank you all for your help on this topic.  The issue had to do with the static goal, the visual was creating a line at .95 for every date, even if the date did not include the values being measured.  Changing "goal_target_windows = 0.95" to the measure below fixed the problem. 

    __goal_target_windows = 
IF('public fact_asset_vulnerability_finding_date'[__windows_os_goal] > 0.00, 0.95, BLANK())
//0.95

     Thanks.

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi tvm_analyst ,

 

Have your issue be resolved?Could you please provide more details about it If it still not be soleved? Please don't have any Confidential Information or Real data in your reply.

 


Best regards,

 

  • tvm_analyst's avatar
    tvm_analyst
    Frequent Visitor
    6 years ago

    Thank you all for your help on this topic.  The issue had to do with the static goal, the visual was creating a line at .95 for every date, even if the date did not include the values being measured.  Changing "goal_target_windows = 0.95" to the measure below fixed the problem. 

    __goal_target_windows = 
IF('public fact_asset_vulnerability_finding_date'[__windows_os_goal] > 0.00, 0.95, BLANK())
//0.95

     Thanks.