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)?
Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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)?
Solved! Go to 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
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
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
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
Thank you so much. Worked like a charm 🙂
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |