Forum Discussion
ClementDavid
1 year agoFrequent Visitor
Table filtered with data from another table who has a relationship is not working
I have a visual showing the status of tickets (=issues). This comes from one table. I have another table containing "labels". The tickets can have 0 to X labels. The relationship between t...
ClementDavid
1 year agoFrequent Visitor
Thank you for your feedback.
I have tested with the new version of Power BI and same result/problem.
However the formula you provide does not work. Count does not accept more than 1 argument.
Can you please explicit what you attend to measure with it?
Bibiano_Geraldo
Super User
1 year agoYou're right, i forgot to close parenteses in count function, try the bellow expression.
If you can attach the sample .pbix file its will be great, NOTE, with no sensitive data.
Thank you
test =
CALCULATE(COUNT([Label Name]), FILTER([YOUR_TABLE, [LABEL NAME] = "contractUpdate"))