Forum Discussion
Jit007
2 years agoHelper II
Divide by applicable values
I'm new to PBI & need help in below topic. I have data as below Q1 NA 100. Record No. 10 Record Yes. 25. Record Total - 135 checked records Yes = 10 score & No = 00. NA-Not applica...
- 2 years ago
Check this. You can replace _parameterNotNA by _parameter if you want to see also NA vs YesNo in _current part of code.
Applicable dufoq3 = VAR _parameter = SELECTEDVALUE('Table Test'[Q1A Parameter Checked]) VAR _parameterNotNA = IF(_parameter <> "NA", _parameter) VAR _current = CALCULATE( //SUM('Table Test'[Q1 score]), COUNTROWS('Table Test'), KEEPFILTERS('Table Test'[Q1A Parameter Checked] = _parameterNotNA) ) VAR _yesNo = CALCULATE( //SUM('Table Test'[Q1 score]), COUNTROWS('Table Test'), 'Table Test'[Q1A Parameter Checked] IN {"yes", "no"} ) VAR _result = DIVIDE(_current, _yesNo) RETURN _result
dufoq3
2 years agoCommunity Champion
Check this. You can replace _parameterNotNA by _parameter if you want to see also NA vs YesNo in _current part of code.
Applicable dufoq3 =
VAR _parameter = SELECTEDVALUE('Table Test'[Q1A Parameter Checked])
VAR _parameterNotNA = IF(_parameter <> "NA", _parameter)
VAR _current =
CALCULATE(
//SUM('Table Test'[Q1 score]),
COUNTROWS('Table Test'),
KEEPFILTERS('Table Test'[Q1A Parameter Checked] = _parameterNotNA)
)
VAR _yesNo =
CALCULATE(
//SUM('Table Test'[Q1 score]),
COUNTROWS('Table Test'),
'Table Test'[Q1A Parameter Checked] IN {"yes", "no"}
)
VAR _result = DIVIDE(_current, _yesNo)
RETURN _result