Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello everybody,
I hope you can help me.
I have a made a matrix visual, but it is showing me some value that are redundant for me.
Row: Market
Column: Year
Values: SellPrice, Profit, Gross Margin and Growth.
My problem:
The Matrix visual shows Growth each year which i dont want. I only want it to show the overall growth in my visual.
The Matrix visual shows the Total sellprice, profit and gross margin, which i dont want. I only want it to show the values for each year.
How do i accomplish this? Is it possible?
I hope you can help me.
Thanks alot!
Best,
Lasse
Solved! Go to Solution.
Hi @LasseA
Your measure can check where it is at every moment by using ISFILTERED:
a) In the general area , ISFILTERED(Market) AND ISFILTERED(Year) will be True
b) In the column subtotals (bottom row) only ISFILTERED (Year) will be true
c) In the row subtotals (far right column) only ISFILTERED (Market) will be True
d) In the Grand Total cell ( bottom right cell) neither ISFILTERED(Market) nor ISFILTERED(Year) will be true
Based on that, you can do the right calculation based on what you want to show in that area.
Does that help?
Hi @LasseA
You may create measures to achive it. Please refer to this similar post and check the first way in the attached file.
HASONEVALUE vs ISFILTERED in DAX
Regards,
Cherie
Hi @LasseA
Your measure can check where it is at every moment by using ISFILTERED:
a) In the general area , ISFILTERED(Market) AND ISFILTERED(Year) will be True
b) In the column subtotals (bottom row) only ISFILTERED (Year) will be true
c) In the row subtotals (far right column) only ISFILTERED (Market) will be True
d) In the Grand Total cell ( bottom right cell) neither ISFILTERED(Market) nor ISFILTERED(Year) will be true
Based on that, you can do the right calculation based on what you want to show in that area.
Does that help?
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |