Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

how can filter Report from blank values were using UNICHAR thresholds

Hi everyone,

any have any idea how can filter Report from blank values were using UNICHAR thresholds

 

without UNICHAR thresholds (Filter working)

 

with UNICHAR thresholds (Filter NOT working)

 

 

how can i apply filter with UNICHAR thresholds?

Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    HI, Anonymous 

    Just try this formula:

    KPI_UTIL 2 = IF(ISBLANK(AVERAGE(AGTPRF_FCT_PERFORMANCE[UTILIZATION_PERCNT]))=FALSE(), UNICHAR(11044))

    Result:

     

    Best Regards,

    Lin

  • Anonymous's avatar
    Anonymous
    7 years ago

    Really appreciated v-lili6-msft  :)

     

    Accept it as the solution

12 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Icon for Super User rankSuper User
    7 years ago

    Hello Anonymous 

    Is your Utilization% done as a measure?  Is it possible that instead of being BLANK it is something like "" (an empty string) which looks blank but is not?

    Would it be possible for you to share a sample .pbix file that has the behavior you are trying to fix?  It is always easier to trouble shoot and actual model.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      as per my investegation,

      Oracle DB Table which I am reading direct query from it 

      doesn`t have any %' '% on the Measure of UTILIZATION_PERCNT :

       

      select A.UTILIZATION_PERCNT from AGTPRF_FCT_PERFORMANCE a
      --where A.UTILIZATION_PERCNT not like '%.%'
      group by A.UTILIZATION_PERCNT
      order by 1

       

      Result: 46 -rows

       

      0.17
      0.19
      0.23
      0.25
      0.33
      0.34
      0.38
      0.41
      0.44
      0.55
      0.58
      0.6
      0.61
      0.67
      0.68
      0.69
      0.7
      0.71
      0.72
      0.73
      0.74
      0.75
      0.76
      0.77
      0.78
      0.79
      0.8
      0.81
      0.82
      0.83
      0.84
      0.85
      0.86
      0.87
      0.88
      0.89
      0.9
      0.91
      0.92
      0.93
      0.94
      0.95
      0.96
      0.98
      0.99
      1

       

       

      and yes it has been identfied as measure

       

      PFA , the pbix.

       

      Kinldy advise

      • v-lili6-msft's avatar
        v-lili6-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        hi, Anonymous 

        Do you try the way I have post above, That should meet your requirement.

         

        Best Regards,

        Lin

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    HI, Anonymous 

    Just try this formula to add a KPI UTL

    KPI UTL = IF(ISBLANK([Avg of UTIL%])=FALSE(),UNICHAR(11044))

    Result:

    BeforeAfter

     

    Best Regards,

    Lin