Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm sorry for bothering but I really want to ask the question. What to do if I want to get the average score for the below attribute while ignoring the blank value. As I a begginer what I do to get the bar chart is I sum all the value for the attribute like this and make the average for the value like this in the image below. But when I doing it like this it does not ignore the blank value when I doing the average because all the CP is from the different table. What I should do gurus to make it ignore the blank value by filter it by region and month.
Example is like this. It still divide by 9 even other value is 0.
Thank you so much in advance for the help given.
Solved! Go to Solution.
I already found the solution for this.
I already found the solution for this.
@Anonymous ,
Averagex(Values(Table[Customer]),[Sum of CP])
Hi @amitchandak , I've try the method you give but it doesn't work as the table for customer is the combination of my sheet in the field. so when i try it it turn on error. because i dont have one table for all the customer value.
@Anonymous , in Values you need to give group by or the not summarized column of visual and that should close by ) like customer
I try to group the measures into one table like the image below but when I insert the the formula for the averagex it still error.
it stated that the group does not have the column why it happen like that?
@Anonymous , is the Sum of CP is measure? Also, you can not use values on a table in this case , you need to give a column
yes the sum of cp is the measure where i sum all the 9 percentage in the table so that I can divide by 9 but the disadvantage that happen is it ignore all the blank value as it divide all the value by 9 eventhough there is table that have less than 9 values as there is blank value in it.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
87 | |
78 | |
62 | |
61 | |
60 |
User | Count |
---|---|
160 | |
114 | |
100 | |
74 | |
65 |