Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don'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.

Reply
seanpratt
Helper III
Helper III

Need to count all "Y" values from measure

‎06-15-2020 11:44 AM

Seems simple enough. I've created a table based on a few measures here and my table now looks like the below. All I want is to see a "card" visualization with "9" on it. But I can't seem to get it to work.

 

Basically we select a date range (Payment table), and then select a value (variable input table) and if the "Days with payments%" column is above the value between those days, we would count them. 

 

Every formula I do results in a CALCULATE has been used in a True/False expression that is used as a table filter expression. This is not allowed. error.

 

Labels:
Message 1 of 7
812 Views
0
1 ACCEPTED SOLUTION
parry2k
Super User
Super User
In response to parry2k

‎06-15-2020 12:24 PM

@seanpratt try this measure

 

Tenants = COUNTX ( VALUES ( Payment[Tenant] ), IF ( [LEAVEIN] = "Y", 1 ) )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

Message 6 of 7
789 Views
6 REPLIES 6
parry2k
Super User
Super User

‎06-15-2020 12:06 PM

@seanpratt share sample data, measure you tried, and expected output and will get back to you with the solution. 

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 2 of 7
807 Views
0
seanpratt
Helper III
Helper III
In response to parry2k

‎06-15-2020 12:15 PM

@parry2k attached file here

 

Sample PBIX 

Message 3 of 7
804 Views
0
parry2k
Super User
Super User
In response to seanpratt

‎06-15-2020 12:20 PM

@seanpratt so you want count where LEAVEIN is "Y", correct?



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 4 of 7
797 Views
0
parry2k
Super User
Super User
In response to parry2k

‎06-15-2020 12:24 PM

@seanpratt try this measure

 

Tenants = COUNTX ( VALUES ( Payment[Tenant] ), IF ( [LEAVEIN] = "Y", 1 ) )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Message 6 of 7
790 Views
seanpratt
Helper III
Helper III
In response to parry2k

‎06-15-2020 12:40 PM

That worked! This is maybe a dumb question, but what does not providing a "false" option do to that formula?

I originally input it as 

COUNTX ( VALUES ( Payment[Tenant] ), IF ( [LEAVEIN] = "Y", 1,0 ) )

 and the ",0" messed things up. So I just copy and pasted yours in and it worked perfectly. What does leaving out the option do to the formula?

 

(I also added you to LinkedIn! A fellow Canuck like me!)

Message 7 of 7
772 Views
0
seanpratt
Helper III
Helper III
In response to parry2k

‎06-15-2020 12:21 PM

Exactly!

Message 5 of 7
795 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

View All