Forum Discussion

simonmcd's avatar
simonmcd
Frequent Visitor
5 years ago
Solved

Help with complex DAX measure

Hi everyone,    I'm pretty new to Power Bi/DAX and jumping into the deep end. I've got a data set that comes from a device monitoring system and trying to work out the up time (total time the devic...
  • lbendlin's avatar
    lbendlin
    5 years ago

    deep end indeed. 

    - your data model needs fine tuning. Explain why you chose the bidirectional search between asset and metrichistory

    - depending on which side you choose the date column from you will get different behavior. If you choose it from the metrichistory then you will only see dates where something happened. If you choose it from the dates table then you can pick full ranges regardless if anything happened or not.

     

    Your data source is the best thing here - event based reporting is a little tricky but it gives you unlimited flexibility unlike snapshot based reporting. You will need to put in some work to compute device status at a certain time (use a measure for that). If you want I can describe the basic steps for how to do that.

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

deep end indeed. 

- your data model needs fine tuning. Explain why you chose the bidirectional search between asset and metrichistory

- depending on which side you choose the date column from you will get different behavior. If you choose it from the metrichistory then you will only see dates where something happened. If you choose it from the dates table then you can pick full ranges regardless if anything happened or not.

 

Your data source is the best thing here - event based reporting is a little tricky but it gives you unlimited flexibility unlike snapshot based reporting. You will need to put in some work to compute device status at a certain time (use a measure for that). If you want I can describe the basic steps for how to do that.

  • simonmcd's avatar
    simonmcd
    Frequent Visitor
    5 years ago

    thanks for the reply, greatly appreciated given the complexity of the task.

     

    I had bidirectional search as this is only a part of the data I need to process and have broken it down into sections to make it more manageable. The bidirectional search was needed when adding another element so decided I wanted to keep this to make it similar to the finished product. 

     

    I have my slicer to choose the dates table to give me the full range of possible dates regardless of the event data.

     

    If you could give me the basic steps that would be really helpful

     

    thanks