Forum Discussion

ENGFAKAYODE's avatar
ENGFAKAYODE
Helper I
4 years ago
Solved

DAX measure comparison

Hello Everyone, I've 2 tables ; Product Dimension Table: Product Name     -      Product Category      -    Product Sub Category Bike                                 Sporting Goods               ...
Need Help
  • onurbmiguel_'s avatar
    onurbmiguel_
    4 years ago

    Hi again, 

    You need to creat a measure not a calculated column: 

     

     

     

    SubCategory Sales = 
var _subcategory = SELECTEDVALUE('Table'[Prod Sub Category])

var _value = 
CALCULATE(
    sum('Table'[tab2.sales]),
    filter (ALL('Table'), 'Table'[Prod Sub Category]= _subcategory)
)
return 
_value

     

    Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
    Best Regards
    BC

onurbmiguel_'s avatar
onurbmiguel_
Power Participant
4 years ago

Hi again, 

You need to creat a measure not a calculated column: 

 

 

 

SubCategory Sales = 
var _subcategory = SELECTEDVALUE('Table'[Prod Sub Category])

var _value = 
CALCULATE(
    sum('Table'[tab2.sales]),
    filter (ALL('Table'), 'Table'[Prod Sub Category]= _subcategory)
)
return 
_value

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! ;-
Best Regards
BC

ENGFAKAYODE's avatar
ENGFAKAYODE
Helper I
4 years ago

Thanks