Forum Discussion
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 wor...
HI, Anonymous
Just try this formula:
KPI_UTIL 2 = IF(ISBLANK(AVERAGE(AGTPRF_FCT_PERFORMANCE[UTILIZATION_PERCNT]))=FALSE(), UNICHAR(11044))
Result:
Best Regards,
Lin
v-lili6-msft
Community Support
Community Supporthi, Anonymous
Do you try the way I have post above, That should meet your requirement.
Best Regards,
Lin
HI v-lili6-msft
I just checked your post,
I tryed by many ways;
But also it`s not working due to syntex errror:
KPI_UTIL = IF(ISBLANK([UTILIZATION_PERCNT])=FALSE(),UNICHAR(11044))))
KPI_UTIL = IF(ISBLANK('AGTPRF_FCT_PERFORMANCE'[UTILIZATION_PERCNT])=FALSE(),UNICHAR(11044))))
KPI_UTIL = IF(ISBLANK(AVERAGE('AGTPRF_FCT_PERFORMANCE'[UTILIZATION_PERCNT])=FALSE(),UNICHAR(11044))))
KPI_UTIL = IF(ISBLANK('AGTPRF_FCT_PERFORMANCE'[UTILIZATION_PERCNT]=FALSE(),UNICHAR(11044))))
KPI_UTIL = IF(ISBLANK(Value('AGTPRF_FCT_PERFORMANCE'[UTILIZATION_PERCNT])=FALSE(),UNICHAR(11044))))
- v-lili6-msft
hi, Anonymous
What is the column "Avg of UTIL%" in this matrix visual? Is not a measure? and what is your data structure?
If possible, please share a simple sample pbix file for us have a test. this will be a great help.
Best Regards,
Lin
I can`t attach file here any idea how
- jdbuchanan71
Super User
Hello Anonymous
You can post it to OneDrive or DropBox and share the link here.
