Need some help with DAX

[Krijgersss]

Hello i need some help with my measure, i'm trying to use this measure in a table visual:

Closed Aantal = CALCULATE(COUNT('newfysic prj_subscription_term'[closed]),'newfysic prj_subscription_term'[closed]="TRUE")

but if i use the messasge i get this error (see screenshot) what do i need to change i want to count the colum wich is a true/false colum

[123abc]

Based on the error message you provided, it seems that there might be an issue with the syntax or the way you're referencing the column in your DAX measure.

Here's the corrected measure for counting the occurrences where the 'closed' column equals "TRUE" in your 'newfysic prj_subscription_term' table:

Closed Aantal = CALCULATE(COUNTROWS('newfysic prj_subscription_term'), 'newfysic prj_subscription_term'[closed] = TRUE())

In this measure:

• COUNTROWS('newfysic prj_subscription_term') counts the rows of the 'newfysic prj_subscription_term' table.
• 'newfysic prj_subscription_term'[closed] = TRUE() filters the rows where the 'closed' column equals "TRUE".

Make sure that the column 'closed' in your table is indeed a Boolean column containing TRUE/FALSE values. If it's stored as text "TRUE" and "FALSE", you may need to adjust the comparison accordingly.

Try this measure and see if it resolves the issue you're encountering.

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.