Forum Discussion

aawde's avatar
aawde
New Member
2 years ago
Solved

Matrix and agregate

Hi, I have an Excel dataset featuring variables such as "Indicateur" with various values and "Region," encompassing both cities and the country name (Canada). The dataset covers the peri...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi aawde ,

    Please try below steps:

    1. below is my test table

    Table:

     

    2. create measure with below dax formula

    Sum for Valeur = SUM('Table'[Valeur])
    Canada Sum =
VAR _a =
    CALCULATE ( [Sum for Valeur], FILTER ( 'Table', [Region] = "Canada" ) )
VAR _b =
    IF ( ISINSCOPE ( 'Table'[Region] ), [Sum for Valeur], _a )
RETURN
    _b

    3. add a martix visual with table fields and measure

    Please refer the attached .pbix file.

     

    Best regards,
    Community Support Team_Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi aawde ,

Please try below steps:

1. below is my test table

Table:

 

2. create measure with below dax formula

Sum for Valeur = SUM('Table'[Valeur])
Canada Sum =
VAR _a =
    CALCULATE ( [Sum for Valeur], FILTER ( 'Table', [Region] = "Canada" ) )
VAR _b =
    IF ( ISINSCOPE ( 'Table'[Region] ), [Sum for Valeur], _a )
RETURN
    _b

3. add a martix visual with table fields and measure

Please refer the attached .pbix file.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.