Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am trying to calcualte a dynamic Max value from one column in Power Query Editor.
An example below where I have different groups, I would like to be able to have dynamic Max value measurement based on one selected group, but not only I would to be able to measure the Max among several number of groups and all the groups.
I am using the Max value for the following step in Power Query to define boundaries.
The final goal is to be able in Power Bi viewer to dynamically change these calculated boundaries based on the groups selected for a same visual.
Thanks for the help
Cheers
Hi @Farwest ,
As @artemus said, we cannot achieve that by power query. We can create a meaure by DAX as below to work on it.
MAX = CALCULATE(MAX('Table'[Probability]),ALLSELECTED('Table'))
For more details, please check the pbix as attached.
Thank you for the answer,
I managed to get out of this problem.
I am still struggling with some other dynamic calculations.
I am trying to use a filter in order to set a measure, it is a single selection filter.
Selected = if(HASONEVALUE('Table['Name]);SELECTEDVALUE('Table[Name]);"ALL")
Dear Community,
I am still struggling with the filter selection,
I created a measure to get the selected value or get "ALL" instead
I'm not entirly sure what you are trying to accomplish, but...
1. If you have loaded all the data you need to calculate the values, you should be able to write a dax measure which does what you want. Chances are one of the quick measures that is offered will work.
2. If you are using direct query, and have not loaded the data needed to calculate the value, then you will probably need to wait until the filter on parameter is implemented in Power Bi. Doing this your self is possible, but quite difficult, and has many caveats.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.