cancel
Showing results for
Did you mean:
Frequent Visitor

## 「構成比 * 値」の計算について

※区分はAのほかにBやCもあります。

どのようなDAX式を記載すればよいでしょうか。

▼×（現在）

 区分する 値 ％ 算出値 あ 10 10 1 あ 10 10％ 1 あ 30 30％ 9 あ 50 50％ 25 合計 100 100％ 100

▼〇

 区分する 値 ％ 算出値 あ 10 10 1 あ 10 10％ 1 あ 30 30％ 9 あ 50 50％ 25 合計 100 100％ 37

※使用しているメジャーは以下の通りです。

％= DIVIDE（[合計]、CALCULATE（[合計]、ALLEXCEPT（ 'table1'、 'table1' [type]））、0）

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft

## Re: 「構成比 * 値」の計算について

Hi, @mintia

Table:

Then you may create two measures as below.

``````% =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALL('Table')
)
)

Result =
SUMX(
'Table',
[%]*'Table'[Value]
) ``````

Result:

Best Regards

Allan

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

2 REPLIES 2
Highlighted
Super User IV

## Re: 「構成比 * 値」の計算について

See, if you are looking for

https://community.powerbi.com/t5/Desktop/Percentage-of-subtotal/td-p/95390

In case it does not help, please provide additional information and mark me with @
My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP,
HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Super User! Linkedin

Microsoft

## Re: 「構成比 * 値」の計算について

Hi, @mintia

Table:

Then you may create two measures as below.

``````% =
DIVIDE(
SUM('Table'[Value]),
CALCULATE(
SUM('Table'[Value]),
ALL('Table')
)
)

Result =
SUMX(
'Table',
[%]*'Table'[Value]
) ``````

Result:

Best Regards

Allan

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

Announcements

#### New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

#### ‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

#### Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

#### Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors