Most RecentNewestMost VotedMost ViewedIf date equals specific date than create a constant Hello, I'm working with a live database and i would like to create a measure where, if table(date[year]) equals 2005 then make a constant 5 else leave blank. If function does not take the date table and I'm not sure if I'm doing it right. I want results like this 2001 3 2002 2003 1 2004 2005 5 2006 But create with DAX. Can someone help? Thank you SolvedFiltering a constant value Hello, I am new to Power BI, so my question is that why this measure example returns 3 rows in a table, while I expected it to return only 1 row. I do not understand how to filter constant values. Thank you. Best regards, André Solved
