Forum Discussion

ravitejaballa's avatar
ravitejaballa
Helper 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.

ravitejaballa's avatar
ravitejaballa
Helper 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!

 

 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi ravitejaballa ,

       

       

      Try this measure

       

      TestMeasure = 
var a = CALCULATE(MAX(deviceHours[timestamp]),ALLSELECTED())
var b = CALCULATE(DISTINCTCOUNTNOBLANK(deviceHours[DeviceID]),FILTER(deviceHours,deviceHours[timestamp] =  a))

RETURN

b

       

       

       


      Regards,

      Harsh Nathani


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

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

      • ravitejaballa's avatar
        ravitejaballa
        Helper III
        6 years ago

        Anonymous 

        Thank for reply,

        I think we are close to solution.

        You solution work for timestamp (7/11/2020) as we have data on this day for all devices.

        But as you can see from below for timestamp - 7/13/2020.

        It failed, because for binLegend it took max date but we need to get last availabe date in the given range.

         

        Excepted output: