Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
@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))
Hi,
thanks, but I already have used ALL() and it does not work:
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |