Calculate numeric distribution

[Alessandra]

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

[v-jiascu-msft]

Hi @Alessandra,

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

Best Regards,

Dale

[Alessandra]

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

[v-jiascu-msft]

Hi @Alessandra,

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

Best Regards,

Dale

[Alessandra]

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

[v-jiascu-msft · 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

[Alessandra]

Thank you SO MUCH @v-jiascu-msft