I need Help to Create Measure in Power BI

[Ahmedalfaydi]

Hello guys ,

Im learning in Power Bi community , So plz i need help for make and create report to Manager and sowthe KPIs

Request-ID	Dep. Name	Task	Unite	start date	End date	Status	PMAssigned
1	IT	Task1	100%	1/1/2024	31/12/2024	In progress	Name1
2	Med	Task2	50%	1/1/2024	31/12/2024	In progress	Name2
3	MOI	Task3	20%	1/1/2024	31/12/2024	In progress	Name3
4	Med2	Task3	0%	1/1/2024	31/12/2024	Late	Name4

[Ahmedalfaydi]

Reaaly thx man and appreciated for help me,,

best regards

[v-jtian-msft · Accepted solution]

Hi,@Ahmedalfaydi .
I am glad to help you.
According to your description, you want to create a KPI report to show KPI to others.
You can create different measures to show the dynamics of the data according to your needs.
Here is the test data I created according to your description, I show the unite of each nameTask in the report and create a measure: calculate the comparison between the unite of the selected task in the slicer and the maximum value of it.
(This is just an example)
You can create as many measures as you want for your KPI reports.

Here is the test data.

I create a measure (named M_).

M_ = CALCULATE(
    MAX('Table'[Unite]),FILTER(ALLSELECTED('Table'[Dep. NameTask]),MAX('Table'[Unite]))
)

You can learn how to add KPIs to reports and how to create metrics by using the following documentation from the Microsoft website
URL:
Key Performance Indicator (KPI) visuals - Power BI | Microsoft Learn
Tutorial: Create your own measures in Power BI Desktop - Power BI | Microsoft Learn
In addition to selecting KPIs to highlight data, you can also select other types of visual.
If you want to show certain highlights, such as the highest Unite and the corresponding NameTask, you can also select "card" to show them individually.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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