Countrows without selection

Hi Marinus,

Thanks for your update.

I’ve reproduced your scenario using sample data matching your raw data structure and achieved the expected output. Create the fallowing dax measure to calculate countrows.

rows = CALCULATE(
COUNTROWS(
FILTER(ALL('table'),
NOT('table'[Aanvraag_Routelint] IN { "Zvg -", "Vlgr -", "Rsdg -", "Odzg -", "Edng -", "Bdlg -", "Svgg -" })
)
)
)

The .pbix file attached demonstrates this working solution with your sample data.

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.