I have a schema with relationships:
Many Revenue[ClientKey] : 1 Client[ClientKey]
filter: << To Revenue
Many ClientType[ClientNo] : 1 Client[ClientNo]
Many ClientType[Year] : Many Date[Year]
Not sure how I will use the last 2 relationships in the pbix; but I set the filter to <<"Both tables">>
I am having issues with basic measures:
Revenue := YTDCALCULATE([Revenue] ,DATESYTD('Date'[Date] ,"31/05" ))
Revenue LYTD := CALCULATE( [Revenue YTD],SAMEPERIODLASTYEAR('Date'[Date] ) )
Revenue displays ok. But Revenue LYTD, displays only the total in a table visualization. Could the relationship somehow make this?
