Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

hiding columns in Matrix

Hi there,   Is it possible to hide columns and keep the total in a matrix. You can do something similar in SSRS by just adding a total at the end of the report.   In the image below, can I hide "...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi Frank,

     

    I was able to solve the problem by turning off word wrap in the matrix setting and dragging the field I wanted to hide.

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

how to write the calculate function fillrate is the calculated measure and ordercases is a column periods also columns .

fillrate=sum of ordered cases/shipped cases 

i have calculated 

AGhyst's avatar
AGhyst
Frequent Visitor
4 years ago

I'm not great at DAX but this is what I would try.  Essentially you can use CALCULATE as a filter. You would need a new measure for each of the fill rate columns you want and you can build it using the fillrate you already did.  I'm not sure what the name of the column field is so...

 

8x1 Fill Rate=CALCULATE(fillrate, [Field]="8x1")

8x2 Fill Rate=CALCULATE(fillrate, [Field]="8x2")

8x3 Fill Rate=CALCULATE(fillrate, [Field]="8x3")

8x4 Fill Rate=CALCULATE(fillrate, [Field]="8x4")

 

Then you would need to make a measure for your Ordered Cases (not sure if you have any filters on cases but if so you could use calculate to get it right).

Ordered Cases Total = SUM[ordered cases]

 

If you want the Total Fill Rate at the end you will need one more measure

Total Fill Rate=CALCULATE(fillrate)

 

Then drop all the measures onto a table in the order you want to see them.   Depending on how your calculations work with your data it can take some fine tuning.  Hopefully, that works--like I said I'm no expert lol.