Forum Discussion

efjw's avatar
efjw
Icon for Helper I rankHelper I
2 years ago
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...
Data Protection
Need Help
Tips and Tricks
Tutorial Requests
  • MFelix's avatar
    MFelix
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi efjw ,

 

Did MFelix's  answer address your question? For streaming datasets, I think the filter pane is great. 

If the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.