Forum Discussion

Ronnie_L's avatar
Ronnie_L
Frequent Visitor
3 years ago
Solved

Measure Help

I need a measure to count the number of times each entry from column "UnitID" is in 39 columns labeled Unit2, Unit3,..., Unit40.    There are about 800 UnitID's. The UnitID is in the form of A101, ...
  • DOLEARY85's avatar
    DOLEARY85
    3 years ago

    Hi, 

     

    could you unpivot the columns in power query then group by the attribute which would be the column title to do the count?

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

DOLEARY85's avatar
DOLEARY85
Resident Rockstar
3 years ago

Hi, 

 

could you unpivot the columns in power query then group by the attribute which would be the column title to do the count?

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

  • Ronnie_L's avatar
    Ronnie_L
    Frequent Visitor
    3 years ago

    I had to include another column with the unpivot and it worked. 

     

    Thank you.

    • DOLEARY85's avatar
      DOLEARY85
      Resident Rockstar
      3 years ago

      Do you have a copy of the PBIX file or the data i could look at?