Forum Discussion

fabconmvp's avatar
fabconmvp
Helper I
1 year ago
Solved

DAX Help

Hello everyone, I need help about dax. First of all ı have a table visualization in PBI. And below the image is example of how PBI visualization. I have 2 table. 1 Fact table and other DimDate tab...
Need Help
  • techies's avatar
    techies
    1 year ago

    Hi fabconmvp 

    Please check this

    Max_Weekly_Value_Per_Week =
    VAR CurrentWeek = SELECTEDVALUE('date'[Week])
    VAR WeeklyValues =
        CALCULATETABLE(
            SUMMARIZE(
                Sheet2,
                'date'[Week],
                Sheet2[Value]
            ),
            ALLEXCEPT('date', 'date'[Week])
        )

    RETURN
        MAXX(FILTER(WeeklyValues, 'date'[Week] = CurrentWeek), [Value])
techies's avatar
techies
Super User
1 year ago

Hi fabconmvp 

Please check this

Max_Weekly_Value_Per_Week =
VAR CurrentWeek = SELECTEDVALUE('date'[Week])
VAR WeeklyValues =
    CALCULATETABLE(
        SUMMARIZE(
            Sheet2,
            'date'[Week],
            Sheet2[Value]
        ),
        ALLEXCEPT('date', 'date'[Week])
    )

RETURN
    MAXX(FILTER(WeeklyValues, 'date'[Week] = CurrentWeek), [Value])
  • fabconmvp's avatar
    fabconmvp
    Helper I
    1 year ago

    Hello,

     

    Firstly, thank you for support. I guess some of the column missing but I modified it in your measure. I'm testing detailly right now that effected other slicers etc. I'm going to accept accept the solution if ı have no question. Thank you for support.
    "

    test =
    VAR CurrentWeek = SELECTEDVALUE(DimDate[WeekNum])
    VAR WeeklyValues =
        CALCULATETABLE(
            SUMMARIZE(
                'Fact',
                DimDate[Date],
                DimDate[WeekNum],
                "Value",
                SUM('Fact'[value])
            ),
            ALLEXCEPT(DimDate, DimDate[WeekNum])
        )

    RETURN
        MAXX(FILTER(WeeklyValues, DimDate[WeekNum] = CurrentWeek),[Value])
    "