Forum Discussion
How to make specific value show when using specific condition?
Hi,
I have a dataset as following:
I wrote a LAST YEAR SALES measure:
Also a Evol%1 measure. One thing need to be noticed is that if the Brand is 3CE, only show Evol% for Campaign 9.9 and 11.11, and it works.
I tried to use another way(using date)to write Evol%. There is a logic between Campaign and Date:
So I wrote a new Evol%2 as following. However, for Date>=2020.09 (which are Campaign 9.9 and 11.11), the Evol%2 for 3CE don't show...
If I change column from Campaign to YearMonth, the Evol%2 for 3CE (Campaign 9.9 and 11.11) show.
So why when columns is Campaign, the Evol%2 for 3CE for 9.9 and 11.11 don't show?
The pbix is attached. Thanks a lot for your time!
https://www.dropbox.com/s/brm81100vtwewiz/Analysis.pbix?dl=0
Hi YunJ ,
Try to do like this.
Because of the table relationship, the column in the Date table can not be filtered in the visual.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Hi YunJ ,
Try to do like this.
Because of the table relationship, the column in the Date table can not be filtered in the visual.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-lionel-msft May I ask why I cannot use Date in the Date table? I already create a relationship between these two Date column in Date table and Campaign table.
Thanks a lot.
Hi YunJ ,
This involves the concept of filter context. In fact, your date table is not filtered at all, so the return values of SELECTEDVALUE('Date'[Year]) and SELECTEDVALUE('Date'[Month]) you define are incorrect.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
