Forum Discussion
Line Chart using COUNTROWS measure only returning blank
Hi,
You had not created a relationship between the tables. You may download my PBI file from here.
Hope this helps.
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.
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
Super UserThanks 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.
The same file has the table 'DataProtectionSummary' as well as that line chart on the first page.
Thanks,
Chris