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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi anamika_singh ,

 

If you want to filter data using a slicer, that’s absolutely possible.
However, if you're using a column from a newly created table as a slicer (instead of directly from your main table), you'll need to create a relationship between the new table and your original table for the slicer to work properly.

Alternatively, you can consider using field parameters, which give you more flexibility to switch between different fields dynamically in your visuals.

 

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi anamika_singh ,

 

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

 

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

 

Regards,

B Manikanteswara Reddy

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi @anamika_singh ,

     

    We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

     

    If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

     

    Regards,

    B Manikanteswara Reddy

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi anamika_singh ,

       

      May I ask if you have gotten this issue resolved?

       

      If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

       

      Regards,

      B Manikanteswara Reddy