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, but in PowerBI, it must show something like this:

 

 

Thanks

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

6 Replies