Forum Discussion
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...
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
Where do I place the above code and syntax?
Create a Dax - New measure