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

Ashish_Mathur's avatar
Ashish_Mathur
Super User
1 year ago

Hi,

Share the raw data.  Share data in a format that can be pasted in an MS Excel file.

anamika_singh's avatar
anamika_singh
Frequent Visitor
1 year ago

Hi Ashish,

 

I think the data I shared can be pasted in excel, please let me know if that's not the case:)

 

Thanks,

Anamika

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    1 year ago

    What you have shared is the result of a matrix visual, not the raw data from where you created it.