Power BI - Group a measure by a column; which is static in created visualiastion

[Jaspal1996]

Hi,

A question for Power BI users.

Have tried searching for this question, but no luck; and I hope I can explain it properly.

I have data that contains a parent code, and a city, with Yes and No answers.

• I have created one measure that gives the % of Yes to No.
• I have created another measure that counts all cities that has a percentage above or equal x%, and another that counts all cities under y%.

However, these measures only works to what is displayed in the table visualisation, when I remove city, the measure output changes, i.e. I need the city in the table to display the correct measures. Ideally, I need to only group these by parent code, such as below. I have the table on the left

• Measure 1 gives the % of all Yes over total (Yes + No)
• Measure 2 indicates 1 when above >=98% and 0 when below

I am hoping to be able to group this into the right table, that is a count of 1 and 0 (of that Measure 2); grouped into Parent Code.

Hopefully I explained correctly and there is a simple solution! Thanks