cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Create calculated dimension field based on measure value

Hi all

I want to show a Pie chart

Dimension=Utilization staus Measure = No of Emp Id

Ex:

when I select week= 2/8/2019

• AVG_384 is Fully Utilized (40+60= 100%)
• US_1 is Fully Utilized (70+15+5+10 =100%)
• US_2 is Partially Utilized (50%)

when I select week= 2/8/2019 and Project = B

• AVG_384 is Partially Utilized (60%)
• US_1 is Partially Utilized (15%)
• US_2 is Partially Utilized (50%)

How can i achive this logic?

 week Emp id Project Utilization % Utilization 2/8/2019 AVG_384 A 40 Partially Utilized 2/8/2019 AVG_384 B 60 Partially Utilized 2/8/2019 US_1 A 70 Partially Utilized 2/8/2019 US_1 B 15 Partially Utilized 2/8/2019 US_1 C 5 Partially Utilized 2/8/2019 US_1 D 10 Partially Utilized 2/8/2019 US_2 B 50 Partially Utilized 2/9/2019 AVG_384 A 100 Fully Utilized 2/9/2019 US_1 B 50 Partially Utilized 2/9/2019 US_1 D 40 Partially Utilized 2/9/2019 US_1 E 10 Partially Utilized 2/9/2019 US_2 E 100 Fully Utilized

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

## Re: Create calculated dimension field based on measure value

Based on my test, you could refer to below steps:

Create below measure:

`Measure = CALCULATE(SUM(Table1[Utilization %]),ALLSELECTED(Table1[Utilization]))`

Create visual and add related fields, you could see the correct result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Community Support Team

## Re: Create calculated dimension field based on measure value

Based on my test, you could refer to below steps:

Create below measure:

`Measure = CALCULATE(SUM(Table1[Utilization %]),ALLSELECTED(Table1[Utilization]))`

Create visual and add related fields, you could see the correct result:

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Regular Visitor

## Re: Create calculated dimension field based on measure value

Thanks @v-danhe-msft

I tried, but I can't achieve my scenario

• when I select week= 2/8/2019
• Pie chart want to show Fully Utilize =2 and Partially Utilized=1
• when I select week= 2/8/2019 and Project = B
• Pie chart want to show Partially Utilized=3
Community Support Team

## Re: Create calculated dimension field based on measure value

I could not understand your former sentense:

when I select week= 2/8/2019

• AVG_384 is Fully Utilized (40+60= 100%)
• US_1 is Fully Utilized (70+15+5+10 =100%)
• US_2 is Partially Utilized (50%)

when I select week= 2/8/2019 and Project = B

1. AVG_384 is Partially Utilized (60%)
2. US_1 is Partially Utilized (15%)
3. US_2 is Partially Utilized (50%)

• when I select week= 2/8/2019
• Pie chart want to show Fully Utilize =2 and Partially Utilized=1
• when I select week= 2/8/2019 and Project = B

Pie chart want to show Partially Utilized=3

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team