How to count the output of measure without using calculated column

[Anonymous]

I am new to power bi. Currently I am trying to count the output of a measure and show it in pie chart.

The original measure is kind of like below:

Pass = IF(SELECTEDVALUE(Table1[Quality]) = [Latest Test], "Y", "N")

I want to count the output of Result and show it in the pie chart. Below picture is achieved using calculated column. But the problem is that they are not responding to the changing filter (We are using period filter).

Is it possible to be done using measure? or can it be done so that it will recalculate and change in pie chart according to the changing filter?

[Anonymous · Accepted solution]

Dear @lbendlin ,

Thank you for the reply.

Sorry for the delay in replying your post as I was away from work. I just got the solution from here. Though I have to change a little bit, so far the result are great and I am still validating the results.

[Anonymous]

HI @Anonymous,

Thank you for sharing the solution, I think it will be helpful if others have similar requirements.🙂

Regards,

Xiaoxin Sheng

[lbendlin]

Please provide sanitized sample data that fully covers your issue. Paste the data into a table in your post or use one of the file services. Please show the expected outcome.