Forum Discussion
Count Text Measure
Hi I have a measure that will let me know if someone is expected to make a target Expected to Make Target = IF([Hours needed per Month]<=[MTD Expected Hours]+40, "Yes", "No") However, I don'...
Hey Anonymous
Create the following two measureCount of No = CALCULATE(COUNT(SQL[Expected to Make Target]), SQL[Expected to Make Target] = "No")
Count of Yes = CALCULATE(COUNT(SQL[Expected to Make Target]), SQL[Expected to Make Target] = "Yes")
and use them to plot cards and pie charts, you will get following result
If this helps you, please mark my solution as accepted so that others can find this quickly when they face a similar issue. Thank you!
Hey Anonymous
Create the following two measure
Count of No = CALCULATE(COUNT(SQL[Expected to Make Target]), SQL[Expected to Make Target] = "No")
Count of Yes = CALCULATE(COUNT(SQL[Expected to Make Target]), SQL[Expected to Make Target] = "Yes")
and use them to plot cards and pie charts, you will get following result
If this helps you, please mark my solution as accepted so that others can find this quickly when they face a similar issue. Thank you!