cancel
Showing results for
Did you mean:
Helper I

## Calculate numeric distribution

Hi,

In tableau, I've calculate the numeric distribution like this: max({ FIXED [Date],[Brand] : sum({ FIXED [BusinessID],[Date],[Brand]: max([Value])})}). And I want to calculate the same formula, but in PowerBI, it must show something like this:

Thanks

1 ACCEPTED SOLUTION
Microsoft

Hi @Alessandra,

The formula of DN could be the one like below according to your data.

```DN Measure =
SUMX (
SUMMARIZE (
'Table2',
'Table2'[Channel],
"MaxSubtotal", MAX ( 'Table2'[Subtotal] )
),
[MaxSubtotal]
)```

Best Regards,

Dale

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

Hi @Alessandra,

This could be easy with using Matrix visual. You can check it out in this file.

Best Regards,

Dale

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

Thanks, but what I really need is the formula of Numeric Distribution (DN) in PowerBI and I didn't see the formula in your file 😞

Microsoft

Hi @Alessandra,

I have no idea about Numeric Distribution (DN). Could you please give an explanation and a sample file?

Best Regards,

Dale

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

Sorry for my **bleep**ty bad explanation, DN is the number of points of sale in which the products are distributed. For example, in the file, I have the column City and Channel (of distribution) , and first, I want to calculate the Max per Channel so I can have the sum of it. That column would be in Power BI the Numeric Distribution (DN).

Microsoft

Hi @Alessandra,

The formula of DN could be the one like below according to your data.

```DN Measure =
SUMX (
SUMMARIZE (
'Table2',
'Table2'[Channel],
"MaxSubtotal", MAX ( 'Table2'[Subtotal] )
),
[MaxSubtotal]
)```

Best Regards,

Dale

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

Thank you SO MUCH @v-jiascu-msft

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors