Forum Discussion

Martijnkamps's avatar
Martijnkamps
Regular Visitor
9 years ago
Solved

Filtered count

Hi everyone,   I am new to Power BI and look to solve the following problem:   I have a table of strings that looks something like this:   Column 1              Column 2 A                     ...
Need Help
  • Martijnkamps's avatar
    Martijnkamps
    9 years ago
    Dear Dale,

    Yes, thank you for your solution! The main problem was with a related table and the data type. It is fixed now.

    Thank you and with kind regards,
    Martijn
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Martijnkamps

 

Hi Martijn Kamps,

 

Actually there are two ways we can go.

Option 1: Use a measure.

Measure =
COUNT ( Table1[Column2] )

Option 2: Add column2 twice, then choose count.

 

 

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Martijnkamps

     

    Hi,

     

    Could you tell me if this worked? What else can I do for you?

     

     

    Best Regards!

    Dale

    • Martijnkamps's avatar
      Martijnkamps
      Regular Visitor
      9 years ago
      Dear Dale,

      Yes, thank you for your solution! The main problem was with a related table and the data type. It is fixed now.

      Thank you and with kind regards,
      Martijn
      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        9 years ago

        Hi Martijn,

         

        My pleasure! I am so glad you have solved the problem.

         

         

        Best Regards!

        Dale