Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
Ive got an excel import of orders.
One of the collums is called [reden van annulering] I want to count all the rows where the Year value is, for example, 2021.
Tried formula below but this won't work. Any one an idea what i should use instead?
annuleringen 2021 = CALCULATE( COUNTROWS(ALL(Sheet0[reden voor annulering] where YEAR ( Sheet0[datum verwijsbrief] ) = 2021)))
Solved! Go to Solution.
Hi @Anonymous .
Try this DAX;
annuleringen 2021 = CALCULATE( COUNTROWS(Sheet0), YEAR ( Sheet0[datum verwijsbrief] ) = 2021)).
Regards,
Sanket.
If this post helps , then mark it as 'Accept as Answer' and give it a thumbs up.
Hi @Anonymous
It seems you want to count the non-blank rows in [reden voor annulering] column for every year. You can first add a Year column to the table.
Then create the following measure
Count Measure = CALCULATE(COUNT(Sheet0[reden voor annulering]),Sheet0[reden voor annulering]<>BLANK())
Put Year column and the measure into a table visual, you will get the count for every year.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Anonymous
It seems you want to count the non-blank rows in [reden voor annulering] column for every year. You can first add a Year column to the table.
Then create the following measure
Count Measure = CALCULATE(COUNT(Sheet0[reden voor annulering]),Sheet0[reden voor annulering]<>BLANK())
Put Year column and the measure into a table visual, you will get the count for every year.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
This way it counts all the rows, i want only to count the rows in column Sheet0[reden voor annulering] idf this is filled with an tekst value (this tekst are different reasons)
Hi @Anonymous .
Try this DAX;
annuleringen 2021 = CALCULATE( COUNTROWS(Sheet0), YEAR ( Sheet0[datum verwijsbrief] ) = 2021)).
Regards,
Sanket.
If this post helps , then mark it as 'Accept as Answer' and give it a thumbs up.
User | Count |
---|---|
19 | |
10 | |
10 | |
9 | |
7 |