Forum Discussion

m1ke909's avatar
m1ke909
Frequent Visitor
7 years ago
Solved

Unique field count help!

New to Power BI here so this could be a silly question.    I need to count the amount unquie text fields within another field and I'm not sure where to start?  Example where C3 is retuning what I ...
Need Help
Tutorial Requests
  • AlB's avatar
    AlB
    7 years ago

    Hi m1ke909 

    Create a new calculate column, where Table0 is the table you show: 

    C3 =
COUNTROWS (
    CALCULATETABLE (
        SUMMARIZE ( Table0; Table0[C1]; Table0[C2] );
        ALLEXCEPT ( Table0; Table0[C1] )
    )
)

     

AlB's avatar
AlB
Community Champion
7 years ago

Hi m1ke909 

Create a new calculate column, where Table0 is the table you show: 

C3 =
COUNTROWS (
    CALCULATETABLE (
        SUMMARIZE ( Table0; Table0[C1]; Table0[C2] );
        ALLEXCEPT ( Table0; Table0[C1] )
    )
)

 

m1ke909's avatar
m1ke909
Frequent Visitor
7 years ago

Thank you! All working now!