cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Alessandra
Helper I
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:

 

DN.JPG

 

Thanks

1 ACCEPTED SOLUTION

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.

View solution in original post

6 REPLIES 6
v-jiascu-msft
Microsoft
Microsoft

Hi @Alessandra,

 

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

Calculate_numeric_distribution

 

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.

Hi v-jiascu-msft,

 

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 😞

 

https://ibb.co/crtqkG
https://ibb.co/jAvQKb

 

 

 

 

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.

Hi v-jiascu-msft

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).

 

 https://drive.google.com/open?id=1FsqD5RnYq573kpeBwD6HzgYxPIJ9DDir

 

 

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.

View solution in original post

Thank you SO MUCH @v-jiascu-msft

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

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.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

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

R2 (Green) 768 x 460px.png

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 Kudoed Authors