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.
The same file has the table 'DataProtectionSummary' as well as that line chart on the first page.
Thanks,
Chris
Super UserYou 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.
- Ashish_Mathur
Hi,
You had not created a relationship between the tables. You may download my PBI file from here.
Hope this helps.
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.
Thanks,
Chris
- 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)Thanks,
Chris