Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

not count unpivot extra rows

Hello,   I need to know how to not count the extra rows power bi creates when I unpivot multiple columns?    Im working on survey data so all the questions I am unpivoting to get the responses fo...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous

    I can reproduce your problem

    T

    To solve this, insert a step before "Unpivot columns"

    add index columns from 1

    then create a measure to calculate the count of regions

    Measure = CALCULATE(DISTINCTCOUNT(Sheet5[Index]),ALLEXCEPT(Sheet5,Sheet5[region]))

     

    Best Regards

    Maggie

     

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

Hi Anonymous

I can reproduce your problem

T

To solve this, insert a step before "Unpivot columns"

add index columns from 1

then create a measure to calculate the count of regions

Measure = CALCULATE(DISTINCTCOUNT(Sheet5[Index]),ALLEXCEPT(Sheet5,Sheet5[region]))

 

Best Regards

Maggie

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    v-juanli-msft

     

    Thank you! That worked out great.  I really appreciate your help! :smileyhappy:

  • Rose_T's avatar
    Rose_T
    Frequent Visitor
    3 years ago

    Thank you so much for providing this solution. Works perfectly.