Forum Discussion

efjw's avatar
efjw
Helper 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 aggregates all data. I want to show the latest data and not the aggregation. How do I implement this?

 

 

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.

4 Replies

  • MFelix's avatar
    MFelix
    Super User
    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.

    • efjw's avatar
      efjw
      Helper I
      2 years ago

      Hi! MFelix I am currently using a streaming dataset thus I am unable to create a measure. Do you know any workaround for this? Thanks 🙂

      • MFelix's avatar
        MFelix
        Super User
        2 years ago

        Hi efjw ,

         

        Have you tried using the filter pane and add the date and use the advance filter to get the data in the last 1 day?

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