Forum Discussion

Dom87326's avatar
Dom87326
Helper II
4 years ago

Conditional expression

Hello,    I'm trying to write a complex conditional expression using the IF or SIWTCH.    My data model is the DimDate:   DimCustomer table: CustomerKey CustomerName 094234  A 09...
Dom87326's avatar
Dom87326
Helper II
4 years ago

Hello again, 

 

I'm working on this solution and want to unhide the last years visuals with transparent card if Check Filtered Measure returns TRUE. For now I'm using two conditions:

Check Filtered = 
   AND(HASONEVALUE(DimCustomer[CustomerName]), HASONEVALUE(Fact[Date]))-- Returns True when user selects Customer and Year in filter's pane

However I'd rather want the user to select one filter on DimCustomer and then to check if there's a Date value of 2021 in the Fact for specific client in DAX. As I mentioned before CustomerKey[DimCustomer] 1:* CustomerKey[Fact].

 

Thanks!







tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi Dom87326 
You better use a date table. However, you may try

Check Filtered =
AND ( ISINSCOPE ( DimCustomer[CustomerName] ), ISINSCOPE ( Fact[Date].[Year] ) )