undefined

[syafiqsulaiman]

Hi All,

I'm new here. hope everyone doing fine.

I have difficulty with Power BI.

As you can see from below table. There are two different project with different data budget based on discipline. I need to calculate the overall progress based on Discipline but I can't find the suitable formula to be used in Power BI.
Please give me your feedback about this.

[Anonymous · Accepted solution]

Hi  @syafiqsulaiman ,

Here are the steps you can follow：

1. Create measure.

Overall_Measure =
var _1=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])),[Overall])
var _2=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])),[Discipline Weightage])
return
_1 * _2

By Discipline min =
var _min=MINX(FILTER(ALLSELECTED('Table'),[Project]=MAX('Table'[Project])),[Discipline])
var _1=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])&&'Table'[Discipline]=_min),[Overall])
var _2=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])&&'Table'[Discipline]=_min),[Discipline Weightage])
return
_1 * _2

By Discipline max =
var _max=MAXX(FILTER(ALLSELECTED('Table'),[Project]=MAX('Table'[Project])),[Discipline])
var _1=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])&&'Table'[Discipline]= _max),[Overall])
var _2=SUMX(FILTER(ALL('Table'),'Table'[Project]=MAX('Table'[Project])&&'Table'[Discipline]= _max),[Discipline Weightage])
return
_1 * _2

Title all =
Var _select1=SELECTEDVALUE('Table'[Project])
var _selecr2=SELECTEDVALUE('Table'[Discipline])
return
_select1 &" "& "Overall Progress"

Title min =
MINX(FILTER(ALLSELECTED('Table'),[Project]=MAX('Table'[Project])),[Discipline])

Title max =
MAXX(FILTER(ALLSELECTED('Table'),[Project]=MAX('Table'[Project])),[Discipline])

2. Create three card diagrams for [Overall_Measure], [By discipline min], [By discipline max],

After placing [Title all], [Title min], [Title max] in the Title of the corresponding Card.

[Title all] -- [Overall_Measure]

[Title min] -- [By Discipline min]

[Title max] -- [By Discipline max]

Columns with [Title all] -- [Overall_Measure]:

Format – Title – Text – fx.

Enter Title text –Title .

Format style – Field value

What field should we base this on – [Title all]

Result:

3. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@syafiqsulaiman ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.

[syafiqsulaiman]

Sorry. 
I want to build a progress report which show the the overall progress for Kiko Project by Discipline. 
Each Discipline has their own weightage to be include into the calculation.
Basically the simple calculation will be like:-
Overall * Discipline weightage = Progress
But I have difficulty to filter out between Kiko and Lala Project.

I want to view the result using the card view just like the below attach.

Project	Area	Date	Discipline	Discipline Weightage	Overall
Kiko	AREA LINES - 4"	08-Dec-22	Safety	0.6	2.00%
Kiko	AREA LINES - 4"	08-Dec-22	Safety	0.6	2.00%
Kiko	AREA LINES - 3"	08-Dec-22	Safety	0.6	1.33%
Kiko	AREA LINES - 3"	08-Dec-22	Safety	0.6	1.33%
Kiko	TOPSIDE	08-Dec-22	Electrical	0.4	1.25%
Kiko	TOPSIDE	08-Dec-22	Electrical	0.4	1.25%
Kiko	JACKET	08-Dec-22	Electrical	0.4	0.83%
Kiko	JACKET	08-Dec-22	Electrical	0.4	0.83%
Lala	AREA LINES - 4"	07-Dec-22	Process	0.5	3.00%
Lala	AREA LINES - 4"	07-Dec-22	Process	0.5	3.00%
Lala	AREA LINES - 3"	07-Dec-22	Process	0.5	2.00%
Lala	AREA LINES - 3"	07-Dec-22	Process	0.5	2.00%
Lala	TOPSIDE	07-Dec-22	Structural	0.5	2.50%
Lala	TOPSIDE	07-Dec-22	Structural	0.5	2.50%
Lala	JACKET	07-Dec-22	Structural	0.5	2.50%
Lala	JACKET	07-Dec-22	Structural	0.5	2.50%