Sum of a column based on the the null values from a different column

[manjeshjk]

Hi All,

I have a situation where I need to display the sum of Bank account where the Accounted Date in SAP is null using a mesaure.

Example

Issue Date	Bank Amount	Accounted Date in SAP
1-Jan-23	13333	2-Jan-23
2-Jan-23	3434343
2-Jan-23	23333
4-Jan-23	90899	5-Jan-23
5-Jan-23	9999	5-Jan-23
Total Amt	3571907
Not Accounted Amount in SAP	3457676

Appreciate your feedback

[KeyurPatel14]

Hii @manjeshjk ,
Please try below formula and if this helps you then accept it as a solution and give a kudos so that it can reach to more members.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure whether I understood your question correctly, but please check the below picture and the attached pbix file.

Not accounted amount in SAP: =
IF (
    HASONEVALUE ( Data[Issue Date] ),
    [Total amount:],
    CALCULATE ( [Total amount:], Data[Accounted Date in SAP] = BLANK () )
)