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

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