Forum Discussion

dkbbr's avatar
dkbbr
Regular Visitor
2 years ago
Solved

Matrix visual

Hi, My english is so bad explain what i'am struggling for but hope you can understand.  In Matrix visual i wanna see our  store's customers that sales over 10m and which category item is these custo...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

    Please check the below picture and the attached pbix file.

     

     

     

     

     

    Sales with condition =
VAR _conditioncustomerlist =
    FILTER (
        VALUES ( customer[customer] ),
        CALCULATE (
            SUM ( sales[sales] ),
            ALL ( category[category] ),
            ALL ( 'year'[year] )
        ) >= 10
    )
RETURN
    CALCULATE ( SUM ( sales[sales] ), customer[customer] IN _conditioncustomerlist )

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
2 years ago

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

 

 

 

 

 

Sales with condition =
VAR _conditioncustomerlist =
    FILTER (
        VALUES ( customer[customer] ),
        CALCULATE (
            SUM ( sales[sales] ),
            ALL ( category[category] ),
            ALL ( 'year'[year] )
        ) >= 10
    )
RETURN
    CALCULATE ( SUM ( sales[sales] ), customer[customer] IN _conditioncustomerlist )