Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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.
Solved! Go to Solution.
@v-rouge Maybe:
Measure 1 = COUNTROWS(FILTER('Table',[Column1]=[Column2]))
Measure 2 = COUNTROWS(FILTER('Table',[Column1]<[Column2]))
Measure 3 = COUNTROWS(FILTER('Table',[Column1]>[Column2]))
@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 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
13 | |
13 | |
12 | |
11 |