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.

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Try changing the datatype of the target measure to percentage:

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

  • 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,