Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Ignore date-table relationship inside a measure

Hi,

I have a matrix visual, in which date table is represented as Rows and measures in columns. "Receivables" is a measure that is extracted from a snapshot-table that contains data on the receivables and is run on a monthly basis. "Future payments" is a measure that calculates planned future payments of all receivables allocated to each month. 

 

I need to extract the cumulative future payments from the current receivables in each month to see how it is going to amortizized since June. One way to do it would be to create a measure of cumulative future payments and extract them from Receivables. 


How can I fix the value of "Receivables" displayed in June such that it appears the same in each month instead of only in June. Is there a way to ignore the date-table relationship?

Other ways to solve this problem are also welcomed. 

Thanks for your help!

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous , You can use all

    CALCULATE(sum(Table[Receivables]),all('Date'))

    or'

    CALCULATE(firstnonblankvalue('Date'[Month]),sum(Table[Receivables]),all('Date'))

     

    or you can use crossfilter

     

    CALCULATE(sum(Table[Receivables]),crossfilter ('Date'[Date], Table[Date], none))

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi,

       

      thanks, but I already have used ALL() and it does not work:

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Just to clarify that I need to get the receivables run on June from snapshot data that contains the receivables run multiple times on different months.

        I need to get the status of the receivables from June but to display them in every row in the visual despite the date.