Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi All,
I am trying to calculate count of rows from Table1, filtering from collumn1 value = duplicate, and collumn 2 value = 40
How can I create a measure for the above?
Any help would be great!!
"I am a screen reader user"
Solved! Go to Solution.
Hi @PB10 ,
How about this?
CALCULATE( COUNTROWS(table1), table1[col1] = "duplicate", table1[col2] = 40 )
Does this work for you? Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
oops let me try again I might have got my error
Hi @PB10 ,
How about this?
CALCULATE( COUNTROWS(table1), table1[col1] = "duplicate", table1[col2] = 40 )
Does this work for you? Let me know 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! | |
#proudtobeasuperuser | |
Hi @tackytechtom thanks for this...
I am getting this error
I checked both collumns are datatype = whole numbers ... what might be something I can fix?
Check out the July 2025 Power BI update to learn about new features.