Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi everyone, I want to create a matrix table that looks something like the table below. In the table, I will show the target value for each tier, and I have an Actual column to check which tier does it belong to and Position column will state the current tier.
E.g., Current actual value is 2,500 and it's greater than Tier 2 and lower than Tier 3, hence it will be parked under Tier 2.
My problem here is how can I check which tier do I belong to and display the actual value and tier number in the same row?
This is how my Dim_Tier looks like and it has no relationship with Fact_Actual
Regards,
BK
Solved! Go to Solution.
Hi, @Anonymous
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
In my opinion, I think you need to create a Dim Tier Table like below.
https://www.dropbox.com/s/iwnv2ax7g28mvag/beekee.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi, @Anonymous
Please check the below pictures and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
In my opinion, I think you need to create a Dim Tier Table like below.
https://www.dropbox.com/s/iwnv2ax7g28mvag/beekee.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: https://www.linkedin.com/in/jihwankim1975/
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |