Forum Discussion
Solved
COUNTIFS in Power BI
Hello all, Hoping someone can help. I'm trying to recreate the below excel formula in Power BI =COUNTIFS(G:G,"<="&H:H,AL:AL,"") I've tried combinations of Count = COUNTROWS(FILTER( ...
Hi Dan27,
Based on this sample data, is 3 the desired result? If so, please new a measure and add it to card visual.
Measure1 = CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[G]<=Table2[H]))
For more advice, please illustrate your requirement with actual sample data and desired result rather than just the Excel functions.
Regards,
Yuliana Gu
v-yulgu-msft
Microsoft Employee
Microsoft EmployeeHi Dan27,
Based on this sample data, is 3 the desired result? If so, please new a measure and add it to card visual.
Measure1 = CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[G]<=Table2[H]))
For more advice, please illustrate your requirement with actual sample data and desired result rather than just the Excel functions.
Regards,
Yuliana Gu