Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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 () )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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.
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 () )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
21 | |
19 | |
12 | |
10 | |
9 |
User | Count |
---|---|
30 | |
25 | |
15 | |
13 | |
10 |