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.

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

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's avatar
    ImprovingCL
    Regular Visitor
    5 years ago

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

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • ImprovingCL's avatar
        ImprovingCL
        Regular Visitor
        5 years ago

        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