Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
v-rouge
Regular Visitor

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@v-rouge Maybe:

 

Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2]))

Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2]))

Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

3 REPLIES 3
Fowmy
Super User
Super User

@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 🙂

YouTube, LinkedIn

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Greg_Deckler
Super User
Super User

@v-rouge Maybe:

 

Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2]))

Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2]))

Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))

 


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Genius - that worked. Thanks so much @Greg_Deckler! I'll mark it as solved now.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors