Not seeing 0 Count Months

Question

I have this measure as my Y Axis, but it does not show the 0 months on my chart visual as expected?

Test Count of Total Gross Incurred +0 =

VAR __Max = MAX('CalendarTable'[Dates])

VAR __Count = COUNT(LossRun[Total Gross Incurred]) + 0

VAR __RT = COUNTROWS(FILTER(ALL('LossRun'), [InceptionYear] <= __Max))

VAR __Result = IF(__RT = 0, BLANK(), __Count)

RETURN

__Result

What I am missing to get 0 months to show?

fowmy · Answer

bdehning&nbsp;Try this measure:
Test Count of Total Gross Incurred +0 =
  VAR __Max = MAX('CalendarTable'[Dates])
  VAR __Count = COUNT(LossRun[Total Gross Incurred]) + 0
  VAR __RT = COUNTROWS(FILTER(ALL('LossRun'), [InceptionYear] &lt;= __Max))
  VAR __Result = IF(__RT == 0, BLANK(), __Count)
RETURN
  __Result
Or right click on the column assinged to the X-Axis and Choose "Show Item with no Data"

bdehning · Answer

Well, with your measure I get 0's again, but also 0's for months prior to InceptionYear, which I do not want. I do not want to see 0's if prior to InceptionYear. Ideas?

Both X-Axis items are text and show items with no data does nothing.

fowmy · Answer

bdehning&nbsp;Sharing a dummy Power BI file representing your scenario would be beneficial. You can save the Power BI file on Google Drive or any other cloud storage platform and provide the link here. Kindly ensure that permission is granted to open the file.

bdehning · Answer

See what you can do.&nbsp; &nbsp;I have left Company C as the selection.&nbsp; They have Inception Date of 7/1/22 so only want to see 24 months including 0 months.&nbsp; I have filter for Rolling Months that restricts visual to 60 months if data is available. Company B and C meet that criteria.&nbsp; &nbsp;I need help in solving this.&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;https://www.dropbox.com/scl/fi/l0ygu5v7flqb990gs9ewt/Test-Get-Rid-of-Extra-Zero-Months.pbix?rlkey=8r2adudukpglpeigb9nqbnwrc&amp;dl=0&nbsp;

bdehning · Answer

In what I sent I have one to many relationship between CalendarTable and Table2 using Dates and Year.&nbsp; I can use Year to Year and have many to many relationship and all my other pages still work, but the Year Month page we are trying to solve is different but still not right.&nbsp; Many to Many shows the months but no 0's.&nbsp; &nbsp; &nbsp;&nbsp;

Forum Discussion

Not seeing 0 Count Months

6 Replies

Related content

Counting Active employees per month

Count previous months

Counting nulls

Count for current month

Month to Month Flow Calculation