Forum Discussion

Julianvesga's avatar
Julianvesga
Frequent Visitor
7 years ago
Solved

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...
Need Help
  • vivran22's avatar
    vivran22
    7 years ago

    Julianvesga 

     

     

    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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You can use the following measure:

Count if Mimick = CALCULATE( COUNTROWS( Table1)  , FILTER( Table1, Table1[time] <=.1))
  • Julianvesga's avatar
    Julianvesga
    Frequent Visitor
    7 years ago

    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.

    • vivran22's avatar
      vivran22
      Community Champion
      7 years ago

      Julianvesga 

       

       

      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

      • Julianvesga's avatar
        Julianvesga
        Frequent Visitor
        7 years ago

        excellent its work, thank you....one questions and i consider that is symple...how i can have relation between two matrix that are in defferents page (big matrix), for example I have a matrix with information about several countries and in the other matrix I have the same countries but with numeric data, and in the first matrix I give click within the matrix to a country, and I want that in the another one show me just this countries ..... this without using filters only with the click. thank you