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.

tvm_analyst's avatar
tvm_analyst
Frequent Visitor
6 years ago

Thanks for the quick response.  Unfortunately I get the same issue.  I played around different datatypes for each of the measures, but nothing changes.

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

Hi JarroVGIT ,

 

Sorry for that, but we cannot reproduce this issue on Power BI Desktop(December 2019), could you please use "See Data" to verify if the measure calculte the right value? Please don't have any Confidential Information or Real data in your reply.

 

 


Best regards,