Forum Discussion

ribisht17's avatar
ribisht17
Super User
9 months ago
Solved

MINX with Temp Table

Hello Community,    I want to show Scores from different location and then pick the one with the lowest score.   Actually I need to show this via Bar Chart hence needed a temp table to sh...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    9 months ago

    Hi,

    Please try something like below.

     

    test_minx_fixed = 
IF(
    CONTAINSSTRING(SELECTEDVALUE(Location_Temp[Location]), "Over"),
    MINX(
        FILTER(ALL(Location_Temp[Location]), Location_Temp[Location] <> "Overall Minimum"),
        CALCULATE(SUM(Fact_Employee_Training[Score]))
    ),
    CALCULATE(
        SUM(Fact_Employee_Training[Score]),
        Dim_Employee[Location] = SELECTEDVALUE(Location_Temp[Location])
    )
)

     

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
9 months ago

Hi,

Please try something like below.

 

test_minx_fixed = 
IF(
    CONTAINSSTRING(SELECTEDVALUE(Location_Temp[Location]), "Over"),
    MINX(
        FILTER(ALL(Location_Temp[Location]), Location_Temp[Location] <> "Overall Minimum"),
        CALCULATE(SUM(Fact_Employee_Training[Score]))
    ),
    CALCULATE(
        SUM(Fact_Employee_Training[Score]),
        Dim_Employee[Location] = SELECTEDVALUE(Location_Temp[Location])
    )
)

 

 

  • ribisht17's avatar
    ribisht17
    Super User
    9 months ago

    Hi Jihwan_Kim 

     

    Great this is working,accepting this as Solution , but I am still not sure why the below is not working ?

       MINX(

            VALUES(Dim_Employee[Location]),
            CALCULATE(SUM(Fact_Employee_Training[Score]))
        )

     

    Same DAX is working in the below scenario

     



    Regards,

    Ritesh