Forum Discussion
Measure showing same value when plotting on table or visual
melhajj , Try it in the way given in this blog
melhajj , Try it in the way given in this blog
Thank you so much amitchandak ! the link you provided has helped me so much , it is exactly what I needed.
Quick question: Why for CURRENTY EMPLOYEES did you use COUNTX function whereas for HIRED and TERMINATED you used COUNT ? a small explanation would be helpful for me to understand more and build on top of what you provided.
Regards,
Hi melhajj ,
The COUNT function counts the number of cells in a column that contain non-blank values. We need to use a column in it. For COUNTX function, it counts the number of rows that contain a non-blank value or an expression that evaluates to a non-blank value, when evaluating an expression over a table.
You could reference the blog to learn the difference between the two functions.
