Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Help Converting an Excel countifs function into Power BI

Hi all,   I am new to the forum and new to Power-Bi and I really need a little help.   I have been given an excel sheet and asked to convert it to Power-Bi. I am really stuck with 1 formula in pa...
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

Actually, there are no concepts of cells and rows like Excel in Power BI. You can try it like below. Please post a sample here. Because we need a function like Max, Min etc. to determine the 1st cell in Aisle column. 

Measure =
CALCULATE (
    COUNTROWS ( Table1 ),
    FILTER ( Table1, Table1[Criteria1] = max(1st cell in Aisle column) && Table[Criteria2] = 1 )
)

 

Best Regards,

Dale