Forum Discussion

OceanExplorer's avatar
OceanExplorer
Icon for Helper I rankHelper I
1 year ago
Solved

Visual Calculation - how to group sales on a table visual

Hi, in this table visual, both columns are created from visual calculation: I want to add a new visual calcualtion column that sum sales by territory, desired output:   I wrote DAX q...
Need Help
OceanExplorer's avatar
OceanExplorer
Icon for Helper I rankHelper I
1 year ago

Thanks a lot! This DAX works for our requirement. Just one more question, the column that used in PARTITIONBY() has to be the original field in the data model, correct? We can't partition by a visual calculation derived column, right? 

  • Irwan's avatar
    Irwan
    Icon for Super User rankSuper User
    1 year ago

    hello OceanExplorer 

     

    Glad to be a help.

    And yes it has to be original field as far as i know.

     

    Thank you.