Line Chart using COUNTROWS measure only returning blank

[ImprovingCL]

I am new to PowerBI so this is probably a novice question.  I have a very simple table that I am trying to represent on a line chart but my COUNTROWS is returning a BLANK value, which is expected, but the suggestions from other posts to add 0 to the COUNTROWS return value or using the IF and ISBLANK combination do not seem to be working for me.

I created a measure as shown below.

LabelActivites = IF(ISBLANK(COUNTROWS('Table')), 0, COUNTROWS('Table'))

In my chart below, my settings are:

X Axis = Date

Values = LabelActivities

Legend = Activity

As can be seen, my measure is still returning blank values instead of '0'.

Any help in what I am overlooking would be greatly appreciated!

[PhilipTreacy]

Hi @ImprovingCL 

That measure shouldn't return Blank if your table contains the rows as shown in your image.

Have you used a Card visual to verify the value in the LabelActivities measure?

Can you please share your PBIX file?

Regards

Phil

[ImprovingCL]

Hi @PhilipTreacy,

I can see in a Card Visual that the value being returned looks correct.  I have put my PBIX file in the link below.  

Shared Folder 

In the PBIX, the first page contains the visual using the data I am actually trying to represent correctly, but my "Sample" table is in there as well.

Thanks,

Chris

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[ImprovingCL]

@Ashish_Mathur,

Thanks for the reply, that definitely looks like it fixes my sample chart, but when I try to apply that same approach using COALESCE to my production data 'DataProtectionSummary' on the first page, I do not get the same expected results.

I've also created a second Calendar based on my 'DataProtectionSummary' table as well just as you have done in the sample, but that seems to result in the line chart having constant values instead.

Could I be overlooking something?

Thanks,

Chris

[Ashish_Mathur]

You are welcome.  If my previous reply helped, please mark it as Answer.  As regards your second question, I cannot comment unless i see the file.

[ImprovingCL]

@Ashish_Mathur,

The same file has the table 'DataProtectionSummary' as well as that line chart on the first page.  

Thanks,

Chris

[Ashish_Mathur]

You simply have not followed what i shared in my solution PBI file.  Neither have you created the Calendar Table nor have you written the measure.  Please study my solution carefully and replicate i on your file.

[ImprovingCL]

Hi @Ashish_Mathur ,

I've gone ahead and updated the file to apply your approach.  I created a Calendar2 table and written a new measure in the DataProtectionSummary table as LabelActivities2 that mirrors what you had done with the sample data, but I am showing my results as just being a flat lines versus the expected values.

Data Protection.pbix 

Thanks,

Chris

[Ashish_Mathur]

Hi,

You may download my PBI file from here.

Hope this helps.

[ImprovingCL]

@Ashish_Mathur ,

I may not be explaining my issue clearly.  I've modified my PBIX file to remove the Sample data as that was just temporary to try to help me identify how to create the measure to show what I was looking for.  Your first repsonse addressed that in the Sample data, but when trying to apply that to my real data, I do not get the expected results.

When I use this as my measure, my results are a flat lines in the line chart over my calendar versus showing data points for each date.

Measure = COALESCE(COUNTROWS('DataProtectionSummary'),0)

Data Protection.pbix 

Thanks,

Chris

[Ashish_Mathur · Accepted solution]

Hi,

You had not created a relationship between the tables.  You may download my PBI file from here.

Hope this helps.

[ImprovingCL]

@Ashish_Mathur ,

Awesome, thank you that does exactly what I was trying to do!

Thanks,

Chris