Forum Discussion

ImprovingCL's avatar
ImprovingCL
Regular Visitor
5 years ago
Solved

Line Chart using COUNTROWS measure only returning blank

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, bu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

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

    Hope this helps.

ImprovingCL's avatar
ImprovingCL
Regular Visitor
5 years ago

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's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

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

Hope this helps.

  • ImprovingCL's avatar
    ImprovingCL
    Regular Visitor
    5 years ago

    Ashish_Mathur ,

     

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

     

    Thanks,

    Chris