Forum Discussion

lpd82's avatar
lpd82
Helper I
4 years ago

calculate static value with filter

Howdy!   How do I formulate "InitialQTY" to yield the result below with  filter Data="Current" applied?  There are other meta data the table such as locations, so I want the "InitialQTY" to summari...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lpd82 

I created a sample with the data you provided . For the value of InititalQTY you returned above result1 and result 2, I don't quite understand your calculation logic, you can take a look at my sample.

Create a measure to sum the QTY by 'Table'[Data] and 'Table'[CreateDate] .

InititalQTY = CALCULATE(SUM('Table'[QTY]),ALLEXCEPT('Table','Table'[Data],'Table'[CreateDate]))

Then add a slicer to filter 'Table'[Data] .

The final result is as shown :

I have attached my pbix file , you can refer to it .

      

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lpd82's avatar
lpd82
Helper I
4 years ago

Ailsa - I appreciate you're working on this.  When I filter "current"; the initital date dropped off the table and yield the incorrect value.  I want the values from 12/31 as the initital value always.  The initial date is dynamic, so I cannot hard code 12/31.  In otherwords, 1,491,200 should always be the subtal for current.

 

thanks