Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Dynamic Filtering for each column for table

Hi  I would like to calculate the value where one particular column should not be affected by one of the filter .  Dataset -  I would like to sum the number for each value present in C...
DAX
DAX Commands and Tips
DAX help needed
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

    Base on color code: =
    CALCULATE (
    SUM ( Data[Number] ),
    TREATAS ( VALUES ( Color[Color Code] ), Data[Color Code] )
    )
     
    Base on category: =
    CALCULATE (
    SUM ( Data[Number] ),
    TREATAS ( VALUES ( Category[Category] ), Data[Category] )
    )
     
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

Base on color code: =
CALCULATE (
SUM ( Data[Number] ),
TREATAS ( VALUES ( Color[Color Code] ), Data[Color Code] )
)
 
Base on category: =
CALCULATE (
SUM ( Data[Number] ),
TREATAS ( VALUES ( Category[Category] ), Data[Category] )
)