Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

DAX Help

I'm not entirely sure this is possible, but I'll give it a shot.   A little background, the relevant dataset involved is a: Customer Dimension table  Item Sales Fact Table Date Table  Each ar...
  • Anonymous's avatar
    Anonymous
    8 years ago

    For anyone checking this thread I was able to use a What-If Parameter to make something pretty close to what I was looking for.

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi CRamirez,

 

Modify more measure as below and check if it can meet your requirement:

 

Sales TEST =
CALCULATE (
    SUMX (
        VALUES ( 'fct Item Sales'[CustID] ),
        SUM ( 'fct Item Sales'[SalesAmount] )
    ),
    ALLSELECTED ( dim_dates[date1] )
)

Regards,

Jimmy Tao

Anonymous's avatar
Anonymous
Not applicable
8 years ago

v-yuta-msft,

 

I apoligize, I needed this to work as a calculated column in order to use as a filter. This measure you have does work perfectly for this specific use-case but I completely misstated my requirement. Is there anyway to have this functionality as a calculated column?

 

My end goal is being able to use the numeric slicer to show total customer sales for selected dates. The slider would then be able to be used to filter out customers based on cumulative sales over dynamic time ranges.