Forum Discussion
Solved
Remove aggregation for gauge visual with PowerBI Semantic model (streaming dataset)
Hi! I am creating a gauge on powerBI desktop using a powerBI sematic model (streaming dataset) and I want to show real-time data. Although I have selected the no calculation onpton, powerbi still agg...
Hi efjw ,
For that you need to create a measure that pick up the latest data depending on the setup and the calculation you need it may be something similar to this:
Current Value = CALCULATE ( SUM(Table[Column]), FILTER(ALL(Calendar), Calendar[Date] = MAX(Table[Date]))Be aware that I do not know how you have your model so this may not be the correct syntax.
Hi efjw ,
For that you need to create a measure that pick up the latest data depending on the setup and the calculation you need it may be something similar to this:
Current Value = CALCULATE ( SUM(Table[Column]), FILTER(ALL(Calendar), Calendar[Date] = MAX(Table[Date]))
Be aware that I do not know how you have your model so this may not be the correct syntax.
