Forum Discussion

Farrah24's avatar
Farrah24
Frequent Visitor
3 years ago
Solved

How to show max value all the time

Hi!

I have data consist of app name, category, date, index A, index B, and index C. Refer to picture below,


I want to show the index in scatter plot visualisation. For example i choose Index A as a X-axis and Index C as a Y-axis. The scatter plot equipped with date play axis. So in each date we can check the movement of the app. However, the scale of the X-Axis and Y-Axis also changes over time. How to make the scale constant with maximum value all the time from index A and Index C?

 

I try using measure to extract the maximum value with dax below, but it also changes over time when i start to play the date play axis. 

MaxAIndex = max('Index App'[Index A])
MaxCIndex = max('Index App'[Index C])
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Farrah24,

    You can add a variable with summarize function to summary the app name and correspond max index value, then you can use iterator function sumx to aggregate the max values of different app groups.

    Measure Totals, The Final Word 

    Regards,

    Xiaoxin Sheng

3 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi  ,
    It seems you need to ignore Date filter context.
    Try something like :
    MaxAIndex = calculate (max('Index App'[Index A]), all('yourTable[date]))
    Did I answer your question? Mark my post as a solution! Appreciate your Kudos 

     



    Farrah24

    • Farrah24's avatar
      Farrah24
      Frequent Visitor
      3 years ago

      thankyou for the reply!

      I've tried the code and it still didn't work. the maximum value still changes over ti I attached link to access the pbix and dataset to make it easier 
      App Index PowerBI & Dataset 

      Thanks in advance!

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi Farrah24,

        You can add a variable with summarize function to summary the app name and correspond max index value, then you can use iterator function sumx to aggregate the max values of different app groups.

        Measure Totals, The Final Word 

        Regards,

        Xiaoxin Sheng