Minif Statements in Power BI

[Randomuser]

Good Morning Power Bi Community,

I am moving for Excel to Power BI and am having trouble finding the formulas I want in the transition.

I currently am using an if-minif statement in excel below.  What type of formula would I need to use in a measure to get this result 

=IF(MINIFS(I:I,D: D,[@[OPTION_CATEGORY]])=[@Driver],[@Driver],0)

[Ashish_Mathur]

Hi,

Select a dataset and show the expected result.

[v-juanli-msft]

Hi @Randomuser

I use your formula in excel, but i can't make it clear.

According to this article, the last parameter should be a scalar, but you are using a column.

Could you share your screenshot about how this formula works in your excel?

Or could you give an example what resula you want to get using this formula?

Then I could work out how to translate these formula in Power BI.

Best Regards

Maggie