Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 |
---|---|
22 | |
10 | |
9 | |
8 | |
8 |