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 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