Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have a summary table as per below.
I have the MIN and MAX values of Avg Sales by Season.
I have created a measure to determine the value of Season that corresponds to the MAX value.
But I cannot work out how to create a measure to determine the value of Season that corresponds to the MIN value.
Any help would be greatly appreciated.
Solved! Go to Solution.
Hi @AussieClyde ,
Min season = CALCULATE(min('Table'[SEASON]),Filter(ALL('Table'),'Table'[aVG SALES]= MIN('Table'[aVG SALES])))
I used my own values, but put your table names and column names in and this will work
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @AussieClyde ,
Min season = CALCULATE(min('Table'[SEASON]),Filter(ALL('Table'),'Table'[aVG SALES]= MIN('Table'[aVG SALES])))
I used my own values, but put your table names and column names in and this will work
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.