How to add GL Code=2101010 into sum(GL_PM_20[C/D]) ?

[Anonymous]

Hi All

https://www.dropbox.com/s/4akhkmwwpb3b2uw/GL_PMC_v003.pbix?dl=0

[amitchandak]

@Anonymous , Try like

calculate(Sum(GL_PM_20[C/D]),filter(GL_PM_20, GL_PM_20[GL Code] ="2101010"))

[Anonymous]

Hi Amit

My PBI file :-

https://www.dropbox.com/s/nzh6ghckoj9e8q6/GL_PMC_v003_.pbix?dl=0

When i try your expression , no error , but when i add STOCK AMT to my table ,  it display error.

[Anonymous]

Hi @Anonymous ,

What's the expected result you want? Only show the rows with GL Code=2101010?

Best Regards,

Jay