Forum Discussion
Comparing two columns for Card visual
Hello, I am new to DAX expressions so hoping someone can help.
I have two columns from a SharePoint List source. I want to compare Column 1 to Column 2 if it is equal to, greater than or less than and then display the number of rows in a Card visual (so essentially I will have 3 Card visuals with a number in each - one for equal to, one for greater than and one for less than).
I've tried new measures but everything I put in so far is invalid.
Thanks in advance.
v-rouge Maybe:
Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2])) Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2])) Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))
3 Replies
v-rouge
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂
v-rouge Maybe:
Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2])) Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2])) Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))Genius - that worked. Thanks so much Greg_Deckler! I'll mark it as solved now.
