Percent of Status Changes

[Anonymous]

Hello, 

I am new to PowerBI and i am trying to build a report that measures the staus changes in a month and displays it in a percentage form. 

To explain it better, the report is connected to a sharepoitnt list that keeps a track of ideas flowing in from an idea generation tool. The report need to measure the total ideas that are coming in a month. It also needs to measure the status changes that occur for ideas in that month. Then display it in a percent format.

The status has 5 types. For review is default and anything else is considered a feedback. Which means i need it to measure when it gets changed. 

Can someone pls help me with this?

[Anonymous]

This is a row of data from the list i can post here. What i am looking for should look something like this in the powerbi report:

Basically the status types are for review(default), pending more information, backlogged, approved, Not progressing. I need the report to register any other status other than for review is a feedback given and count that in the feedback provided column. I need it to also count all feedbacks in total and calculate the percent of feedback given for the percent of feedback given column. All this needs to be on a montly basis too. Hope that explains my dillemma a bit better 

Month	Count of ideas	Feedback Provided	Percent of feedback provided
Jan	20	12	60%

[Anonymous · Accepted solution]

Hi @Anonymous,

Here is the sample that I built based on the random dummy data. You can refer to the following measure formulas to get the count and percentage based on conditions if suitable for your requirement.(notice: they can dynamic response with status filter selections)

Feedback =
CALCULATE (
    COUNT ( 'Table'[ID] ),
    FILTER ( ALLSELECTED ( 'Table' ), [Status] <> "review" ),
    VALUES ( 'Table'[Date] ),
    VALUES ( 'Table'[Status] )
)

Rate =
DIVIDE (
    [Feedback],
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        ALLSELECTED ( 'Table' ),
        VALUES ( 'Table'[Date] ),
        VALUES ( 'Table'[Status] )
    )
)

Regards,

Xiaoxin Sheng

[Anonymous]

Hi @Anonymous,

Can you please share some dummy data that keep the raw data structure with expected results to pasted here with table format? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng