Hi experts, could you help to convert this Tableau expression to Power BI expression?

[MeiYing]

{FIXED [COUNTRY], [REGION], [ORDERDATE] : SUM (
IF [KPIGROSS] = 'Yes'
THEN 1
ELSE 0
END) }

Thank you so much. I really have no idea on how to convert.

[johnyip]

This should be dependent on how you wish to display this measure.

Do you want it to be displayed in a matrix/table or in a card?

You can provide some sample picture of your desired output, and the data structure as well if you can, so people can better understand the question and answer that.

[MeiYing]

Thanks John for the reply. I just want to keep it as a calculated field which will then be used to calculate an aggregation of percentage KPIGross for each week. The aggregate percentage KPI gross will be displayed as a line in bar chart. Below is the screenshot from the tableau.