Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
RandomUser06
Frequent Visitor

Percent of Status Changes

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?

1 ACCEPTED SOLUTION

Hi @RandomUser06,

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] )
    )
)

 

1.PNG

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
RandomUser06
Frequent Visitor

RandomUser06_0-1675825896786.png

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 

 

MonthCount of ideasFeedback Provided

Percent of feedback provided

Jan2012

60%

 

Hi @RandomUser06,

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] )
    )
)

 

1.PNG

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
v-shex-msft
Community Support
Community Support

Hi @RandomUser06,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.