The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a table similar where I need to count up number (by month) of rows that have Y value in them. I tried below but it is not returning values at all. I am able to count rows but I need to count only the Y rows. What do I have wrong?
#Y = COUNTROWS(filter(TABLE,TABLE[OverThres]="y"))
date | over threshold | amount |
1/1/2023 | y | 5,000.00 |
1/2/2023 | n | - |
1/3/2023 | y | 2,000.00 |
1/4/2023 | y | 6,000.00 |
1/5/2023 | n | 100.00 |
Solved! Go to Solution.
@jenniferhoward Is your column named "over threshold" or "OverThres"? You might try:
#Y = COUNTROWS(FILTER(ALL('Table'),[over threshold] = "y"))
Also, make sure you don't have any non-printing characters or anything in your over threshold column. (Trim and Clean in Power Query)
@jenniferhoward Is your column named "over threshold" or "OverThres"? You might try:
#Y = COUNTROWS(FILTER(ALL('Table'),[over threshold] = "y"))
Also, make sure you don't have any non-printing characters or anything in your over threshold column. (Trim and Clean in Power Query)
thanks so much, formula worked!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
38 | |
21 | |
18 | |
15 |
User | Count |
---|---|
124 | |
39 | |
28 | |
24 | |
23 |