Forum Discussion
Solved
Percentages without null values
Hello colleagues. I would like to know if it is possible to make a DAX that allows to do the following: 1. I have a form that several people have answered (Form 1, Form2,...). 2. The form is about...
hello ponchibonos
please check if this accomodate your need.
a. no filter selected. i am not sure why sum of null is 115 in your description, it should be 135 (20+20+30+10+40+15)
b. Form 1 selected
c. Question 1 selected
Create a new measure with following DAX
Value Sought =
var _Sum1 = SUM('Table'[Percentage result])
var _Sum2 =
CALCULATE(
SUM('Table'[Percentage of each Question]),
FILTER(
'Table',
not ISBLANK('Table'[Percentage result])
)
)
Return
DIVIDE(
_Sum1,
_Sum2
)Hope this will help.Thank you.
hello ponchibonos
please check if this accomodate your need.
a. no filter selected. i am not sure why sum of null is 115 in your description, it should be 135 (20+20+30+10+40+15)
b. Form 1 selected
c. Question 1 selected
Create a new measure with following DAX
Value Sought =
var _Sum1 = SUM('Table'[Percentage result])
var _Sum2 =
CALCULATE(
SUM('Table'[Percentage of each Question]),
FILTER(
'Table',
not ISBLANK('Table'[Percentage result])
)
)
Return
DIVIDE(
_Sum1,
_Sum2
)
Hope this will help.
Thank you.
Amazing!!
Works perfectly.
Thanks