Forum Discussion

KY's avatar
KY
Regular Visitor
10 years ago
Solved

Dynamically calculate differences based on slicer slection

Hi,    I am trying to present the data in a line and clustered column chart,date in the axis, company as column series, and Assets as the column value. In slicer, I have Company (A, B, C....F).   ...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    10 years ago

    KY

    Please check if you can follow below steps. To make a better presentation, I'm using some data simple.
    Suppose the dataset is as

     

    1. Create an index column
      rank = RANKX(Table3,Table3[Company],,,Dense)
    2. Create a measure
      Measure = ABS((SUMX(FILTER(Table3,Table3[rank] = MIN(Table3[rank])),Table3[Revenue])-SUMX(FILTER(Table3,Table3[rank] = MAX(Table3[rank])),Table3[Revenue])))
    3. Drag a line and clustered column chart

    Check more details in the uploaded pbix.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

KY

Please check if you can follow below steps. To make a better presentation, I'm using some data simple.
Suppose the dataset is as

 

  1. Create an index column
    rank = RANKX(Table3,Table3[Company],,,Dense)
  2. Create a measure
    Measure = ABS((SUMX(FILTER(Table3,Table3[rank] = MIN(Table3[rank])),Table3[Revenue])-SUMX(FILTER(Table3,Table3[rank] = MAX(Table3[rank])),Table3[Revenue])))
  3. Drag a line and clustered column chart

Check more details in the uploaded pbix.

geominded1's avatar
geominded1
New Member
6 years ago


Trying to figure out how to display this same information within a matrix. When adding the Measure to Values, we end up getting extra columns added, along with the correct subtotal Measure that we only really want. Any way to turn off those intermediary column values?