Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sum elements in a table discriminating one dimension

Hello,   I am looking for a way to sum elements in a table discriminating one dimension while including another dimension. Here in this example, I want the sum of errors for the "Jean" and "Shirt"...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Ventes measure: = 
CALCULATE( SUM(Data[Value]), Data[Attribute] = "Ventes")

     

    Forecast measure: = 
CALCULATE( SUM(Data[Value]), Data[Attribute] = "Forecast")

     

    Error measure: =
IF (
    ISINSCOPE ( 'Month'[Month] ),
    ABS ( [Ventes measure:] - [Forecast measure:] ),
    SUMX (
        DISTINCT ( Category[Category] ),
        CALCULATE (
            ABS ( [Ventes measure:] - [Forecast measure:] ),
            ALL ( 'Month'[Month No], 'Month'[Month] )
        )
    )
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Ventes measure: = 
CALCULATE( SUM(Data[Value]), Data[Attribute] = "Ventes")

 

Forecast measure: = 
CALCULATE( SUM(Data[Value]), Data[Attribute] = "Forecast")

 

Error measure: =
IF (
    ISINSCOPE ( 'Month'[Month] ),
    ABS ( [Ventes measure:] - [Forecast measure:] ),
    SUMX (
        DISTINCT ( Category[Category] ),
        CALCULATE (
            ABS ( [Ventes measure:] - [Forecast measure:] ),
            ALL ( 'Month'[Month No], 'Month'[Month] )
        )
    )
)

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Adapted the code to my needs and it worked great. Thanks