How can I create a metric which changes a result to do predictions?

[JoanElGran1899]

Hi Everyone,
I want to create a metric which change any result of column Y bigger than 0, and convert this result in 100% and column N to 0%.
This is to do predictions.
I show you an example:

Does anyone have any idea of how to doing it?

Thank you very much for trying to help me!!

[v-eqin-msft · Accepted solution]

Hi @JoanElGran1899 ,

Please create measures:

N Measure = IF(MAX('Table'[Y])>0,0,MAX('Table'[N]))

Y Measure = IF(MAX('Table'[Y])>0||MAX('Table'[Y])=BLANK(),1) 

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PaulDBrown]

Please follow the recommedations outlined in this thread to help us help you:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523