Matrix Table Question

[Anonymous]

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

[Jihwan_Kim · Accepted 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/