Forum Discussion

B_Smith's avatar
B_Smith
Frequent Visitor
8 years ago
Solved

DAX Comparison Measure

Hello, sorry if there are multiples, was not appearing in the topic list!   I'm trying to get a Dax calculation right for a measure and having some problems. I know it's some combination of allsele...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Try this:

    [SubCategory Sales] =
VAR CurrentSubCategory =
    VALUES ( ProductTable[Product Subcategory] )
RETURN
    CALCULATE (
        SUM ( Sales[Sales] ),
        ALL ( ProductTable[Product Name] ),
        ProductTable[Product Subcategory] = CurrentSubcategory
    )

    and this:

    [Category Sales] =
VAR CurrentCategory =
    VALUES ( ProductTable[Product Category] )
RETURN
    CALCULATE (
        SUM ( Sales[Sales] ),
        ALL ( ProductTable[Product Name] ),
        ProductTable[Product Category] = CurrentCategory
    )
Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Why would you need something like this?

 

  1. Create a relatioship from the Product Name column of the Sales table to the Product Name column of the Product Dimension Table.
  2. Drag the three columns from the Product Dimension table
  3. Write this calculated field formula

=SUM(Data[Sales])

 

This will create a visual with 2 columns.