Forum Discussion

totamum's avatar
totamum
Icon for Helper I rankHelper I
7 months ago
Solved

Count Distinct Values based on another column in Power Query

I need to count the number of ip_addresses for each username.  Group By doesn't seem to work as I cannot select another column when I choose Count Distinct Rows.  I've tried a number of DAX measures but they don't work either.  Any ideas anyone??  I've pasted my table below removing sensitive data.  Many thanks

 

 

Need Help
  • totamum's avatar
    totamum
    7 months ago

    Thanks but none of these worked.  I ended up just connecting to the sheet via Close Load & To in PowerQuery and selecting Only Create Connection and Add This Data to the Data Model and then creating a Pivot Table from the Data Model with a column for usernames and IP addresses as Distinct Values.

7 Replies

  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support
    7 months ago

    Hi totamum Thanks for reaching out to the Microsoft fabric community forum.

     

    Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format (e.g., Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information.

    Looking forward to your response.

    Best regards,
    Lakshmi.

    • totamum's avatar
      totamum
      Icon for Helper I rankHelper I
      7 months ago

      Thank you for your reply.  I don't have any sample data.  I was hoping the structure and column names would be enough.

      • v-lgarikapat's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support
        7 months ago

        Hi totamum 

         

        The logic has been implemented using sample data, and the PBIX file is attached for your reference. Kindly review and let me know if you have any questions or require any additional details.

         

         

         

         

        Thanks,

        Lakshmi