How to make my Straight table provide total amount ?

[admin11]

Hi All

I have a inventory striaght table , it unable to return total amount.

Below is my PBI file :-

https://www.dropbox.com/s/70q8gysy0d7earj/PBT_V2021_382%20TI_SI_GL%20striaght%20table%20cannot%20get...

[Ashish_Mathur · Accepted solution]

Hi,

Write this measure

Measure 4 = SUMX(SUMMARIZE(VALUES('RATE'[SOURCE]),'RATE'[SOURCE],"ABCD",[AMT_ON_HAND_SGD_1]),[ABCD])

Hope this helps.

[admin11]

@Ashish_Mathur 

Thank you very much

[Ashish_Mathur]

You are welcome.