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])
anmolmalviya05's avatar
anmolmalviya05
Super User
1 year ago

Hi fabconmvp, Hope you are doing good,

Please try the below measure:

Max Value per Week =
MAXX(
VALUES(DimDate[Week]),
CALCULATE( SUM(Fact[Value]) )
)
If this post helps to answer your question, please consider accepting it as a solution so others can find it more quickly when they face a similar challenge.


Proud to be a Microsoft Fabric community super user


Let's Connect on LinkedIn

Subscribe to my YouTube channel for Microsoft Fabric and Power BI updates.

fabconmvp's avatar
fabconmvp
Helper I
1 year ago

Hello,

 

Thank you for support. However, it didnt work. The values shown as in the first image.