Calculate rate based on criteria in row

[VJR]

Hello,

I'm new to powerBI and this forum! I hope my explanations are clear enough and someone can help me 🙂

I'm trying to find a rate based on my data, based on a column with only 2 values (Yes/No). I want to find my rate based on those 2 values. Here are my formulas:

• RateYes = DIVIDE(COUNT(CoverageDB[Nb Item]);(COUNT(CoverageDB[Nb Item])+COUNTBLANK(CoverageDB[Nb Item])))
• RateNo = DIVIDE(COUNTROWS(GROUPBY('CoverageDB';CoverageDB[Loading country code];CoverageDB[Loading country and area];CoverageDB[Delivery country code];CoverageDB[Delivery Country code and region];"Count";SUMX(CURRENTGROUP();'CoverageDB'[Nb Item])));SUMX('Total';'Total'[Total]))

Both of these formulas work well independently. What I'm struggling with is doing something as follows:

• Rate = IF(Column="Yes", RateYes, RateNo). PowerBI isn't letting me choose a column for the logical test.

Thanks in advance!

[Zubair_Muhammad · Accepted solution]

Hi

Try with following

Rate = IF(selectedvalue(Column) ="Yes", RateYes, RateNo)

[VJR]

Hi,

Thank you so much, works great!