topic Re: How to count ratio by comparing one column value towards another column value. in DAX Commands and Tips

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

Anonymous — Fri, 13 May 2022 03:14:53 GMT

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.

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

Jihwan_Kim — Fri, 13 May 2022 03:30:52 GMT

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 )

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

Anonymous — Fri, 13 May 2022 03:56:04 GMT

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