Forum Discussion

sirros_iot's avatar
sirros_iot
Helper III
8 years ago

Filtering a measure by value

Hello all!   I have this seaction on a measure... And I would like to get this values by the same Id Measure A =                     VAR ANT = [.MinAT] - ( INT( [.MinAT] / 86400) * 86400)       ...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Diego,

 

Actually, some calculated columns still can be created in the Direct Query mode (not the live connection). You can try to convert [.CiclTime] to a calculated column.

The second approach could be using a measure like below. ([.CiclTime] is the measure)

 

Measure =
AVERAGEX (
    SUMMARIZE (
        'table',
        'table'[id],
        'table'[_ts],
        'table'[_at],
        "CiclTime", [.CiclTime]
    ),
    [Cicltime]
)

 

Best Regards,

Dale

 

sirros_iot's avatar
sirros_iot
Helper III
8 years ago

It isn't returning something..

 

Well, I'm getting the data by streaming

It is portuguese..

 

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi sirros_iot,

     

    Which approach returned nothing? 

    Did you connect to the Power BI Service datasets in the Desktop? The calculated column won't work in this type of connection. 

    How about creating a table visual with only three columns and one measure?

    [id]  [_ts]  [_at]  [measure]

     

     

    Best Regards,

    Dale

    • sirros_iot's avatar
      sirros_iot
      Helper III
      8 years ago

      Hi v-jiascu-msft,

       

      The last one.. But I'm revising it cause I think I did it wrong.

       

      Yes, I connected to the Power BI Services datasets in the Power BI Desktop..

      This is the historical data analysis button, this is my data origin

       

      I am trying to find out how it can work, because I have a measure of the difference between AT and TS(MeasureA), and..

      MeasureA = SUM('Table'[_ts]) - SUM('Table'[_at])

       

      So, my new measure creates a virtual table with other measure.. It is ok? It didn't work when I triyed but I'm searching for a mistake

       

      Thank you for the reply,

      Best Regards,

      Diego

       

       

      • sirros_iot's avatar
        sirros_iot
        Helper III
        8 years ago

        Hi v-jiascu-msft,

        Do you think I can do something with this data? I need to see if I have to request changes in the project

         

        Thanks,

        Best Regards,

        Diego