Forum Discussion

JacobMich's avatar
JacobMich
Regular Visitor
1 year ago
Solved

How do I filter POWERBI data in my visual workspace based on values in two columns?

I am working in PowerBI.  I am looking for a specific filtering and counting of information from an already transformed query.  The raw data of what I am asking for can be seen in the Table Below.  I...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Filtered Count =
    CALCULATE(
    COUNTROWS('YourTableName'),
    FILTER(
    'YourTableName',
    ('YourTableName'[Country] = "US" && 'YourTableName'[Level] = 5)
    || ('YourTableName'[Country] = "MX" && 'YourTableName'[Level] = 4)
    )
    )

    Replace with Table Name as per yours

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi JacobMich,

I hope you had a chance to review the solution shared by danextian ryan_mayu Anonymous . If it addressed your question, please consider accepting it as the solution — it helps others find answers more quickly.
If you're still facing the issue, feel free to reply, and we’ll be happy to assist further.

 

Thank you.