Forum Discussion

MCornish's avatar
MCornish
Responsive Resident
6 years ago
Solved

DAX Convert Text to Number

Hi   I have a table with responses to a questionaire. In the answers column there will be a mix of text and number e.g.   Q: Enter some text    |   This is text Q: Enter a number    |    8   W...
Need Help
  • az38's avatar
    az38
    6 years ago

    Hi MCornish 

    try a measure

    Measure = calculate(
    averagex(
        FILTER(ALL(Table2);
            NOT(ISERROR(VALUE(Table2[Answer])))
        );
    VALUE(Table2[Answer])))

     

    do not hesitate to give a kudo to useful posts and mark solutions as solution

    LinkedIn

az38's avatar
az38
Community Champion
6 years ago

Hi MCornish 

try a measure

Measure = calculate(
    averagex(
        FILTER(ALL(Table2);
            NOT(ISERROR(VALUE(Table2[Answer])))
        );
    VALUE(Table2[Answer])))

 

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn