Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I hope someone can help
I am using a measure to filter data in a table by a date column, however the filter is not working
I want to count the amount of rows in a table where one column is "criteria 1" and another date colum is "this year". The formula accurately seperates "criteria 1" but does not filter by year
Solved! Go to Solution.
Hi @Matt22365
I dont see a symbol ")" in your Year('DataBase'[Date Opened] statement
try
Count No Opened = CALCULATE(COUNTROWS('DataBase'),'DataBase'[Criteria]="Criteria 1",Year('DataBase'[Date Opened])=YEAR(TODAY()))
do not hesitate to kudo useful posts and mark solutions as solution
Linkedin
Hi @Matt22365
I dont see a symbol ")" in your Year('DataBase'[Date Opened] statement
try
Count No Opened = CALCULATE(COUNTROWS('DataBase'),'DataBase'[Criteria]="Criteria 1",Year('DataBase'[Date Opened])=YEAR(TODAY()))
do not hesitate to kudo useful posts and mark solutions as solution
Linkedin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |