Count +0 and too many months

[bdehning]

Here is my Count Visual

Here is my Count +0 Visual

I have been trying to solve this for months.  On the Count + 0 visual the issue is that the customer selected started 7/1/22.  How can not show the 0 months prior to Jul 2022?  

I can not find a sample report to help me solve this.  

I some how need use the Start Date for each company it seems.  So when companies are selected by Slicer, the Month Year starts showng months from their Start Date Month.   

[v-huijiey-msft]

Hi @bdehning ,

Thanks for the reply from Ashish_Mathur , Musadev .

After many days, has your problem been solved?

Was my answer helpful? Was there a test performed?

I would be grateful if you could provide me with sample data for testing, please remove any sensitive data in advance.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[bdehning · Accepted solution]

It's way more complicated for my model, so I moved on.  

[v-huijiey-msft]

Hi @bdehning ,

You need to create a new measure to dynamically calculate the "Count of Total Gross Incurred" from the Start Date of the selected company.

Count of Total Gross Incurred = 
CALCULATE(
    COUNT(LossRun[Total Gross Incurred]), FILTER(
    FILTER(
        ALL('DateTable'), 'DateTable'[Date])
        'DateTable'[Date] >= MIN(Companies[StartDate])
    )
)

I would be grateful if you could provide me with sample data with the personal information erased.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Musadev]

in the Filters Views, Uncheck the Null (blank) option for this visual so it will not show the blank rows. 
You have more dates in the table than the dates you are using for calculations. You have this issue, add the dates to X-axis from the table you are using the values or check the dim_dates table and keep only the dates you have in your FCt table. 

[bdehning]

That is not an option as I use 

Count of Total Gross Incurred = CALCULATE(COUNT(LossRun[Total Gross Incurred])) +0, which provides 0 for months for no count inside where I want and unfortuately outside where I do not want.  

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.