Calculated Measure ignoring null row in Matrix

[ktue]

Hi! Relatively new to Power BI. I'm having an issue with missing calculated measures due to null data.

I've created a matrix with 3 measures. "NEW Total AR Bal," "LM_TOT_AR" (which stands for Last month total ar), and "$ Change in Gross AR Balance". $ Change is supposed to subtract JAN2021's AR Balance from FEB2021. It's broken down by Log type ( A-Inhouse, B - DNFB, etc. ) and month. Please see the attachment for clarification.

My issue is that in FEB2021 there wasn't any Tot AR Bal for Log A. So, because it's null it's completly skipping over Log A for all measures. I tried forcing a zero for NEW Total AR by adding "+0" at the end. That works for NEW Total AR Bal, but it's still not showing any data for LM_TOT_AR or $ Change for Log A.  Yet, the Totals for each measure are calculating correctly at the bottom.

Things I've tried:

1. I've selected "Show items with no data" for the Log Name. But Log A is still not showing.

2. Forcing zeros for NEW_Total_AR, LM_TOT_AR, and $ Change.

Does anyone have any tips? There's gotta be something I can do. Thanks in advance!

 

[amitchandak · Accepted solution]

@ktue , try using time intelligence for that.

Example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))

last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-12,MONTH)))
Previous year Month Sales = CALCULATE(SUM(Sales[Sales Amount]),previousmonth(dateadd('Date'[Date],-11,MONTH)))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

[ktue]

This worked! My Auto date/time Time Intelligence option was turned off -- so I turned that on. Then I created a better date/calendar table and set it as a Date Table. I created a relationship between my date table and my financial data. And replaced the dates variables in my measures and matrix with fields from the date table. I didn't end up needing to use the MTD functions, but your comment definitely helped me get to the right place. Thanks!