Report to display count and sum of Approved and Pending Status based on Specific data

[Anonymous]

Hi All,

Need help on a specific Report which displays the User who had approved the request and pending the request.

Example :

When the User DK,TVs, OM  Access the Report,

I am using RSL UserPrinciple() to Filter the data.

The Report needs to display 

User: DK

Approved: 1

Pending: 1

User: TVs 

Approved: 2

Pending: 1

USer  PM 

Approved: 2

Pending: 1 

I tried Unpivot and other option but not able to accomplish the specific report output. 

SAMPLE  Data 

ID	Title	period	TotalpointsforNomination	Stage1Approver	Stage1Status	Stage2Approver	Stage2Status	Stage3Approver	Stage3Status
1	STM	5/28/2021	100	DK	Approved	TVS	Approved	PM	Approved
2	SOUQ	5/28/2021	100	TVS	Approved	DK	Pending
3	SHT	5/28/2021	100	PM	Approved	TVS	Pending
4	HT	5/28/2021	100	PM	Pending

[Anonymous]

Thanks, Link for the detailed Explanation ...Will check and get back to you.

[v-xulin-mstf]

Hi @Anonymous,

Is your issue solved?

If you still have some question, please don't hesitate to let me known.‌‌

Best Regards,

Link

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

[v-xulin-mstf · Accepted solution]

Hi @Anonymous

You can Duplicate three tables, the transform data as:

Rename the two columns as:

Append the three tables.

Create two measures as:

approved_count = 
CALCULATE(
    COUNT('Count_Table'[Stage_Approver]),
    FILTER(
        ALL('Count_Table'),
        'Count_Table'[Stage_Status]="Approved" && 'Count_Table'[Stage_Approver]=MAX('Count_Table'[Stage_Approver])
     ))

pending_count = 
CALCULATE(
    COUNT('Count_Table'[Stage_Approver]),
    FILTER(
        ALL('Count_Table'),
        'Count_Table'[Stage_Status]="Pending" && 'Count_Table'[Stage_Approver]=MAX('Count_Table'[Stage_Approver])
     ))

Here is the output:

The pbix is attached.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.