Forum Discussion
Solved
Show missing data
I am trying to show all data irrespective of the date slicer I have data like below but when I filter my data based on a date using slicer (1st nov to 2nd nov). As, A3 data is not available betw...
ravitejaballa Well, you are going to need to use a measure. Try this:
test1 =SUM(Data[Value]) + 0
ravitejaballa You will need to use something like ALL in your calculation to remove filter context.
Greg_Deckler ALL didn't help me
It brings required assetID but it sum up all assets value column
test1 = CALCULATE(SUM(Data[Value]), ALL(asset))
ravitejaballa Well, you are going to need to use a measure. Try this:
test1 =SUM(Data[Value]) + 0