Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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"))
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)
View solution in original post
thanks so much, formula worked!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.