Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @sd0021781 ,
I’ve made a test for your reference:
1\I assume there is a table
2\Add a measure
Average = AVERAGEX(
FILTER(
'Table',
'Table'[Column1] <> "-"
),
VALUE(SUBSTITUTE('Table'[Column1], "%", "")) / 100
)
3\Result
Best Regards,
Bof
Hi @sd0021781 ,
I’ve made a test for your reference:
1\I assume there is a table
2\Add a measure
Average = AVERAGEX(
FILTER(
'Table',
'Table'[Column1] <> "-"
),
VALUE(SUBSTITUTE('Table'[Column1], "%", "")) / 100
)
3\Result
Best Regards,
Bof
How to calculate average of the given numbers with (-) in some cells. I want to exclude (-) value while calculating
I have numbers in percentile and - in some filds. How to calculate the average excluding (-)? please help
Hi @sd0021781 - you average agent information measure should be this as below:
Hope it works.
Proud to be a Super User! | |
I calculated as you said but the result shows '0'. Expectation is to exclude dash and calculate the average of remaining numbers like
-
100
100
100
0
-
100
50
-
0
100
Expected answers after ignoring dash should be (550/8)= 68.75
however i am getting 0 as an answer basis the calculation you have provided.
I appreciate your efforts and looking forward to your next reply
Hi @sd0021781 - Can you please add some more details about your query to answer quickly.
please follow the below link:
Re: How to Get Your Question Answered Quickly - Page 5 - Microsoft Fabric Community
Proud to be a Super User! | |
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
26 |
User | Count |
---|---|
97 | |
87 | |
43 | |
40 | |
35 |