Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi ,
I am new to Power BI .
I have created few measures like this.
Solved! Go to Solution.
I two measures, each on a separate card visual. Each card visual has separate filters applied. I want to get the max of the two measures after filters are applied. I have a third measure on it's own card visual that contains the DAX provided in this thread to show the max value between the two measures. However, when filters are selected that apply to both card visuals, the card reads 'blank', and when only filters selected that apply to one card visual, the minumim is shown. Why is this?
Measure = VAR __list = { [TCr1516], [TCr1617], [TCr1718], [TCr1819], [TCr1920] } RETURN MAXX( __list, [Value] )
According to your description, you want to get the max/min among multiple columns. Right?
In this scenario, we need to unpivot the Column B, C,..., F, have them group on Column A. Then calculate the min value within Column A group. Now you can summarize Column A and the calculation into a new table and build the relationship with source table. Please refer to steps below:
1. Click on Column A, select "Unpivot Other Columns"
2. Then filter the empty rows.
3. Create the Min Value measure:
Min Value = CALCULATE(MIN('Table5 (2)'[Value]),ALLEXCEPT('Table5 (2)','Table5 (2)'[Column A]))
4. Create a calculated table:
Table 2 = SUMMARIZE('Table5 (2)','Table5 (2)'[Column A],"Min Value",[Min Value])
5. Build the relationship with source table source table.
is there a way to return the name of the var i.e
[TCr1920]
As what @Ro_ mentioned, is there a way to return the name of the measure instead of the value?
Hello,
Thanks for this it is very useful!
Is there a way to edit this DAX to return the Name of the measure that returned the lowest value as oppose to the value its self?
Thanks,
Ross
am getting an error message boss
previously it is as wholenumber and now changed it as text.. it works now..
User | Count |
---|---|
122 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |