Forum Discussion

ravitejaballa's avatar
ravitejaballa
Icon for Helper III rankHelper III
6 years ago
Solved

Count by Catagory

Hi,   I trying to get number of DeviceID for a each catagory (binLegendColumn). But it has to be for latest value for a given timestamp. As you can see below, i am able to fetch latest hours valu...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.  i have solve it using measures only.

    Hope this helps.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

ravitejaballa , You can try measures like

 

m1 =lastnonblankvalue(Table[timestamp],max(Table[binLegendColumn]))

 

m2 = lastnonblankvalue(Table[timestamp],max(Table[lastValueHours]))

  • ravitejaballa's avatar
    ravitejaballa
    Icon for Helper III rankHelper III
    6 years ago

    amitchandak 

    Thanks for reply,

    I already have these measure in my report.

     

     

     

     

     

     

     

     

    Using this measure, i want to get count of number of deviceID for each legend.

    Like below.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi ravitejaballa ,

       

      Based on your Data No of Distinct Device Id are as below.

       

       

       

       

      In such case you can just use.

       

      (DISTINCTCOUNT(deviceHours[DeviceID])

       

       

       

      How did you get 1 , 2, 1, 1 .

       

      Let me know if I am missing something.

       

      Regards

      Harsh Nathani

      Appreciate with a Kudos!! (Click the Thumbs Up Button)

      Did I answer your question? Mark my post as a solution!