How to find the values in one column is greater than the values in another column by how many times?

[Anonymous]

I have two columns and I need to find how many times the values in one column is greater than the values in another column in DAX.

For Example:

Column_A Column_B

8.07 0.70

I want to know how many times is Column A(8.07) is greater than Column_B(0.07)?

[TomMartens]

Hey,

just create calculated column in your table like so:

new columnname = 
IF('tablename'[Column_A] > 'tablename'[Column_B], 1, BLANK())

This creates a numeric column that you can drag to a card visual and it automatically calculates the number of rows where Column_A is greater than Column_B.

In addition to that you can use the column to filter the rows.

Hopefully this is what you are looking for.

Regards,

Tom

[Anonymous]

Hey, Thanks for the reply. However, I am not looking for the number of rows.  I want to know by how many times does the value in column A is greater than column B

[TomMartens · Accepted solution]

Hey,

please excuse, I misread your question.

Just divide Column_A by Column_B like so:

new columnnam
DIVIDE('tablename'[Column_A], 'tablename'[Column_B], BLANK())

Regards,

Tom

[Anonymous]

Thank you so much. Worked like a charm 🙂