Forum Discussion

jameslat's avatar
jameslat
New Member
1 year ago
Solved

How to have Changing Values in a Matrix Table

Hi, Would appreciate if someone could jump in and make a test file for me because i cannot seem to find a solution anywhere regarding having a matrix table with a changing "values" section:   I ha...
Need Help
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    Hi,

    I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    top 5 sales: = 
SWITCH (
    TRUE (),
    ISCROSSFILTERED ( customer[Customer] ), SUM ( top_5_customers[Vol (L)] ),
    SUM ( sales[Vol (L)] )
)

     

mdaatifraza5556's avatar
mdaatifraza5556
Icon for Super User rankSuper User
1 year ago

Hi jameslat 

Here are the steps that can resolve your issue.

steps
---- Create one dim_store table
----- Create "Year" column in Top5CustBreackdown table

Below is the relationship between the table


and create a measure for your result

result =
SWITCH(TRUE(),
    ISINSCOPE(top5custBreackdown[Customer]), SUM(top5custBreackdown[Vol (L)]),
    ISINSCOPE(top5custBreackdown[year]), SUM(top5custBreackdown[Vol (L)]),
    SUM(stores[Vol (L)])
)



Here is the result