Forum Discussion

Alessandra's avatar
Alessandra
Helper I
8 years ago
Solved

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...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    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's avatar
Alessandra
Helper I
8 years ago

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's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

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