Forum Discussion
rpinxt
Solution Sage
Solution SageCalculation to visual, how to filter
Gabry helped me with the RUNINGSUM value in the new preview feature for visual calcultions. Worked fine : But this table was a simple view of a graph I wanted to make. And that graph would b...
Issue is that you have bad ralation with blank values filtered away from the visual with the filter you put.
32 complaints have no date attached and you are just not considering them.
In this case you need to adjust the measure like this:
Running sum =VAR MaxDate = MAX (dimDate[Date]) -- Saves the last visible dateRETURNCALCULATE ([New-Closed], -- Computes sales amountdimDate[Date] <= MaxDate, -- Where date is before the last visible dateALL ( dimDate[Date]) ,-- Removes any other filters from Date
not ISBLANK(dimDate[Date]))final result:
Gabry
Super User
Super UserIssue is that you have bad ralation with blank values filtered away from the visual with the filter you put.
32 complaints have no date attached and you are just not considering them.
In this case you need to adjust the measure like this:
Running sum =
VAR MaxDate = MAX (dimDate[Date]) -- Saves the last visible date
RETURN
CALCULATE (
[New-Closed], -- Computes sales amount
dimDate[Date] <= MaxDate, -- Where date is before the last visible date
ALL ( dimDate[Date]) ,-- Removes any other filters from Date
not ISBLANK(dimDate[Date])
not ISBLANK(dimDate[Date])
)
final result:
