Forum Discussion

joerykeizer's avatar
joerykeizer
Icon for Helper II rankHelper II
9 years ago

Countifs 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...
Need Help
BhaveshPatel's avatar
BhaveshPatel
Icon for Super User rankSuper User
9 years ago

I think Query Editor would be more easy option than exploring to write complex DAX. 

Sample Data and expected output would be highly appreciated.

  • joerykeizer's avatar
    joerykeizer
    Icon for Helper II rankHelper II
    9 years ago

    I've uploaded some sample data.

     

    The result I want is to rank products within a store by their sales. I'm trying to find an alternative to the RankX functionality which gets really slow for large amounts of data. I don't think the query editor is an option since the sales come from another table through a measure.