Forum Discussion
Function Excell Countifs in Power BI
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
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
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
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
Hi, yes please, with a example a thing is more easy.
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'
