Forum Discussion

anamika_singh's avatar
anamika_singh
Frequent Visitor
1 year ago
Solved

Summarizing a Matrix visual by a specific field

Hi Team,   Can i get help on the below: The below is a matrix visual created based on my dataset:                           Name Has Access Daily Logins Profiles Viewed Re...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hello anamika_singh ,

     

    Thank you for reaching out to Microsoft Fabric Community Forum

     

    Ashish_Mathur lbendlin Thank you for your quick responses.

     

    Please try the below DAX measure to create a calculated table.

     

    finalresult =
    VAR BaseTable =
        ADDCOLUMNS(
            YourTable,
            "Latest Assigned Date",
                CALCULATE(
                    MAX(YourTable[Assigned Date]),
                    ALLEXCEPT(YourTable, YourTable[Name])
                )
        )
    RETURN
    SUMMARIZE(
        BaseTable,
        YourTable[Name],
        "Has Access",
            VAR _LatestDate = MAXX(FILTER(BaseTable, YourTable[Name] = EARLIER(YourTable[Name])), [Latest Assigned Date])
            RETURN
                CALCULATE(
                    MAX(YourTable[Has Access]),
                    YourTable[Assigned Date] = _LatestDate
                ),
        "Daily Logins", SUM(YourTable[Daily Logins]),
        "Profiles Viewed", SUM(YourTable[Profiles Viewed]),
        "Response Rate", AVERAGE(YourTable[Response Rate]),
        "Assigned Date", MAX(YourTable[Assigned Date])
    )

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

    Regards,

    B Manikanteswara Reddy

lbendlin's avatar
lbendlin
Super User
1 year ago

yes, you can do that directly in your table visual (it's not a matrix, unless you use explicit measures?).  Set the last column to aggregate to "Latest". And probably the Response Rate to Average rather than sum.