Forum Discussion

bswud's avatar
bswud
New Member
7 years ago
Solved

Counting character values from multiple columns

I've scrolled at least 20 help threads to no avail—amazes me if there isn't a simple solution out there—but no one has been looking for precisely the same thing as me.   So I have a dataset where s...
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi bswud

    Sorry not to explaining better.

    Before creating measure, i go to "edit queries"->"Transform", select four subject columns, then select "unpivot columns", then "apply&&colse", next create measures.

    Below is the table after transform

     

     

    Best Regards

    Maggie

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi bswud

Test with your table

Create measures

numbers of per subject selected = CALCULATE(COUNT(Table1[subject]),FILTER(ALLEXCEPT(Table1,Table1[subject]),[Value]<>BLANK()))

 

 

Best Regards

Maggie

bswud's avatar
bswud
New Member
7 years ago

Thank you Maggie, that is what I'm looking for, but it doesn't work. I think because I'm not understanding what I should put for [Value], and I'm not understanding how many times I need to iterate the measure (for each subject number column?) I'd appreciate a tiny bit more explanation so I can try and understand the underlying issue.

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    Hi bswud

    Sorry not to explaining better.

    Before creating measure, i go to "edit queries"->"Transform", select four subject columns, then select "unpivot columns", then "apply&&colse", next create measures.

    Below is the table after transform

     

     

    Best Regards

    Maggie