Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Shailesh Kanse]

Hi Team,
I am trying to calculate sum of “Pending Questions” in Matrix Visual. Here I wanted to show “Student” and “Max date Selected” in row and sum of “Pending Questions” in value of matrix visual. File attached below.If someone could help me that would be great.

——————————
Shailesh Kanse
Senior BI Developer
——————————

[Alberto Gastaldo]

Hi Shailesh 
could you please clarify your request ?

Do you need something like this ?

StudendID    Max date   Total

—————————————-
1641     10/05/2020     90
1746     10/05/2020     155
1808     10/05/2020     227

I attached the modified file with the correct measures:

Basically I suggest you to:
1) add a calendar table to your model: this is a best practice any time you play with dates 

2) create a base measure that show the number of pending questions (i called it # of pending questions)

# of pending questions = SUM(StudentPerformance[Pending Qustions])

3) create a running total measure: what you need is basically REMOVE the filter on student and get the number of questions for all student less or equal to the current student

# of pending running total =

   Var currentStudend = SELECTEDVALUE(StudentPerformance[Student ID])

   RETURN

   CALCULATE(

       [# of pending questions],

       StudentPerformance[Student ID] <= currentStudend,

      ALL(StudentPerformance[Student ID])

)

——————————
Alberto Gastaldo
SQL Server & BI sernior consultant and trainer
——————————
——————————————-

[Alberto Gastaldo]

Here is the new PIBX file
Let me know.

Alberto

——————————
Alberto Gastaldo
SQL Server & BI sernior consultant and trainer
——————————
——————————————-

[Shailesh Kanse]

Hi Alberto,
Thanks for your help. This is working for me.

——————————
Shailesh Kanse
Senior BI Developer
——————————
——————————————-