How to display the fashion price in a Matrix visual

[Syndicate_Admin]

Good night!

I would like to show the fashion price in a visual matrix by SKU, by distribution channel... I understand that it must be done with DAX but I do not master the language at all.

My Data Table is called DB which contains the following columns to perform the calculations:

- SKU

- Price (Bs.).

I would like to display the data as follows if possible:

Thanks a lot!

[amitchandak]

@Syndicate_Admin , I am not sure what is the challenge in that.

SKU to ROw, Distribution on column and  Avg price as value

Matrix Visual: https://www.youtube.com/watch?v=M5PvQUy-L_4&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=28

The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[Syndicate_Admin]

Good, of course!

Actually I want to show a detail by SKU and by distribution channel the average price and the Fashion price, something like this:

The problem is that I really don't know how I can show the most repeated price (the Fashion price).