My Table Visual is ignoring the all - filter in my measure

[CecilioCB]

Hi! 

I have a measure 

Measure 3 = CALCULATE(SUM(TemperatureData[Daily Average by Observations]); ALL(TemperatureData[Date]))

The issue I have is that when adding Measure 3 to a Visual Table , the visual table seem to be ignoring the sum and ALL condition. Could anyone advice? I was expecting to see th total sum  along the the entire column for measure 3.

WIth kind regards; C

[Ashish_Mathur · Accepted solution]

Hi,

I wrote these measures

Daily average = AVERAGE(TemperatureData[Daily Average by Observations])

Measure 3 = SUMX(ALL(TemperatureData),[Daily average])

The result of Measure 3 in all rows is 24,022.20

Hope this helps.

[FrankAT · Accepted solution]

Hi,

your measure 3 should read:

=CALCULATE(SUM(TemperatureData[Daily Average by Observations]); ALL(TemperatureData))

Use the whole table TemperatureData inside the ALL() function, not only the column TemperatureData[Date].

Regards FrankAT

[Ashish_Mathur]

Hi,

I cannot spot any mistake in your measure.  Share the link from where i can download your PBI file.

[CecilioCB]

Hi Ashish! 

Many thanks for the quick response. 

Please have a look:  https://we.tl/t-msKT112GtQ

Kind regards; Cecilio.

[Ashish_Mathur · Accepted solution]

Hi,

I wrote these measures

Daily average = AVERAGE(TemperatureData[Daily Average by Observations])

Measure 3 = SUMX(ALL(TemperatureData),[Daily average])

The result of Measure 3 in all rows is 24,022.20

Hope this helps.