Display a branch with the lowest or highest percentage on a card visual

[Tlotly]

Hello.

I have a measure below: 

Stress_Indicator(%) = (CALCULATE(AVERAGE('Client Stress Indicator_centre_level'[Meals_Indicator]) + AVERAGE('Client Stress Indicator_centre_level'[Meat_Indicator])+AVERAGE('Client Stress Indicator_centre_level'[Veges_Indicator]) + AVERAGE('Client Stress Indicator_centre_level'[Weighting_centre]))  + CALCULATE([GroupsinArrears(%)]) + CALCULATE([NrofClientsSaving2%])+ CALCULATE([NrofGroups_DecreasedGroupBal(%)]))/100

I need to create 4 card visuals based on the measure as follows:
1. Branch with the lowest %

2. The lowest % of that branch

3. Branch with the highest %

4. The highest % of that branch

I would also like to card visuals to not display anything if the calendar period has not been selected or if possible to display the results only for the latest period.

I've already tried this measure to diplay the branch name and it works, except that it defaults to "SYSTEM" when the period hasn't been selected.

Resilient Branch = VAR vSummary =

    ADDCOLUMNS ( VALUES ( View_Aff_Region_Branch[Branch Name] ), "Most Resilient Branch", [Stress_Indicator(%)] )

RETURN

    MAXX (

        TOPN ( 1, vSummary, [Most Resilient Branch], ASC ),

         View_Aff_Region_Branch[Branch Name]

    )

Thank you.

[bhanu_gautam · Accepted solution]

@Tlotly 

1. Branch with the Lowest %

DAX
Branch with Lowest % =
VAR vSummary =
ADDCOLUMNS (
VALUES ( View_Aff_Region_Branch[Branch Name] ),
"StressValue", [Stress_Indicator(%)]
)
VAR vFiltered =
FILTER(vSummary, NOT(ISBLANK([StressValue])))
RETURN
IF(
ISFILTERED('Calendar'[Period]), // Replace with your actual calendar column
MAXX (
TOPN ( 1, vFiltered, [StressValue], ASC ),
View_Aff_Region_Branch[Branch Name]
),
BLANK()
)

2. The Lowest % of that Branch

DAX
Lowest % Value =
VAR vSummary =
ADDCOLUMNS (
VALUES ( View_Aff_Region_Branch[Branch Name] ),
"StressValue", [Stress_Indicator(%)]
)
VAR vFiltered =
FILTER(vSummary, NOT(ISBLANK([StressValue])))
RETURN
IF(
ISFILTERED('Calendar'[Period]),
MINX (
vFiltered,
[StressValue]
),
BLANK()
)

3. Branch with the Highest %

DAX
Branch with Highest % =
VAR vSummary =
ADDCOLUMNS (
VALUES ( View_Aff_Region_Branch[Branch Name] ),
"StressValue", [Stress_Indicator(%)]
)
VAR vFiltered =
FILTER(vSummary, NOT(ISBLANK([StressValue])))
RETURN
IF(
ISFILTERED('Calendar'[Period]),
MAXX (
TOPN ( 1, vFiltered, [StressValue], DESC ),
View_Aff_Region_Branch[Branch Name]
),
BLANK()
)

4. The Highest % of that Branch

DAX
Highest % Value =
VAR vSummary =
ADDCOLUMNS (
VALUES ( View_Aff_Region_Branch[Branch Name] ),
"StressValue", [Stress_Indicator(%)]
)
VAR vFiltered =
FILTER(vSummary, NOT(ISBLANK([StressValue])))
RETURN
IF(
ISFILTERED('Calendar'[Period]),
MAXX (
vFiltered,
[StressValue]
),
BLANK()
)

If you want to always show the latest period, you can add a filter in your measure to only consider the latest period:

DAX
VAR LatestPeriod = CALCULATE(MAX('Calendar'[Period]), ALL('Calendar'))
...
FILTER(ALL('Calendar'), 'Calendar'[Period] = LatestPeriod)

[Tlotly]

@bhanu_gautam it works perfectly. Thank you