Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have a matrix where i have brand name and under that products.I am currently showing MTD Revenue Target and want to show Full month target in another column.
How can I show Full month target along with MTD revenue target when I have a Page level filter set to show only MTD records
currently both are same
Thanks,
NJ
Solved! Go to Solution.
Hi @nj17
Please use following DAX code.
Hi @AUDISU
it is working for me.
but I want to know how it is ignoring page level filter? which only showing value for MTD and not whole month
Hi @AUDISU
I have below page level filter on page where i am using Full Month Target.
MTD ia flag in date table for all MTD dates.why this filter not affecting the measure?
Hi @nj17
Please use following DAX code.
User | Count |
---|---|
97 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |