Forum Discussion
Function Excell Countifs in Power BI
Hi Team, i need to found tha result of the following formula in power BI:
COUNTIFS($A$3:$A$16,$E6,$C$3:$C$16,"<="&E$2)
| A | B | C | D | E | ||
| 1 | ||||||
| 2 | Step | Trasactions | time | 0.1 | ||
| 3 | Input | 1 | 0.1 | |||
| 4 | Authorize | 3 | 0.1 | |||
| 5 | Input | 2 | 0.2 | |||
| 6 | Input | 3 | 0.1 | Input | 4 | |
| 7 | Repair | 2 | 0.2 | Authorize | ||
| 8 | Input | 5 | 0.3 | Repair | ||
| 9 | Input | 6 | 0.1 | |||
| 10 | Repair | 3 | 0.2 | |||
| 11 | Authorize | 1 | 0.3 | |||
| 12 | Input | 4 | 0.1 | |||
| 13 | Repair | 1 | 0.1 | |||
| 14 | Authorize | 6 | 0.2 | |||
| 15 | Authorize | 2 | 0.3 | |||
| 16 | Authorize | 4 | 0.3 |
Hi,
Although the formula suggested by Anonymous should solve the purpose and should exclude blanks, but you may try this:
CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[time] <= .1 && Table1[time] <>BLANK()))
Thanks,
Vivek
7 Replies
the formula is working but now some transactions do not have time (blank) and the formula counts them as if they were less than 0.2. How could you avoid having blank caillas not be taken into account?
we are close...thank you.
Hi,
Although the formula suggested by Anonymous should solve the purpose and should exclude blanks, but you may try this:
CALCULATE(COUNTROWS(Table1),FILTER(Table1,Table1[time] <= .1 && Table1[time] <>BLANK()))
Thanks,
Vivek
