Forum Discussion
joerykeizer
Helper II
Helper IICountifs in DAX
Hello, I'm trying to convert a formula from excel to Power BI. In Excel: =COUNTIFS(A:A;A2;B:B;">"&B2) The second range and ">B2" part are giving me some trouble. Your help would be very muc...
joerykeizerHelper II
Helper IIThank you for your reply v-yulgu-msft
The link still works for me but I've uploaded it somewhere else as well -> New sample data link
Anyway so my expected result is this:
In your example A2/B2 should have actually been A1/B1. A1 is a categorical value and B1 is a measure.
Hopefully this will help you understand my question better.
richbenmintz
Resident Rockstar
Resident Rockstarcountif in dax would be foo=calculate(countrows('table'), 'table'[bar] > var)