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

vivran22's avatar
vivran22
Community Champion
7 years ago

Julianvesga 

 

Hi,

 

I am glad the solution worked.

 

For your second scenario, is it possible for you to demonstrate it with some example... dummy data tables along with the desired output?

 

Thanks,

Vivek

Julianvesga's avatar
Julianvesga
Frequent Visitor
7 years ago

Hi, yes please, with a example a thing is more easy. 

  • HotChilli's avatar
    HotChilli
    Community Champion
    7 years ago

    You could use the 'drillthrough' feature.  On Page 2, drag 'country' to the 'Add drillthrough fields here' section.

     

    From Page 1, right-click the country in the matrix and select 'drilthrough'