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,

 

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

Calculate_numeric_distribution

 

Best Regards,

Dale

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    8 years ago

    Hi Alessandra,

     

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

     

    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