How to count ratio by comparing one column value towards another column value.

[Anonymous]

Hi, may i know what should I code if I wanted to know the ratio of the row item that 'PO date' is greater than 'Invoice Date'?
for example, the picture below show 2 row item out of 5 has PO date > Invoice Date. the ratio is 2/5 = 40%.

May I know how can I get this logic in Power BI.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Ratio measure: =
VAR POgreaterthanInvoice =
    COUNTROWS ( FILTER ( Data, Data[PO Date] > Data[Invoice Date] ) )
VAR allcount =
    COUNTROWS ( Data )
RETURN
    DIVIDE ( POgreaterthanInvoice, allcount )

[Anonymous]

It works !! thank you so much, it shows excatly what I am looking for ! Appreciate 😀