Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove only 3 total columns in matrix

Hi guys 

I have a matrix that contains products code and measures that belong to these products however i want to remove 3 total column  from the matrix because it dosen't make a sense for some reasons, here is the screenshot I want to remove only the total of these columns (M_conversion,LY_QANT,YTD_QANT).

Only code_article is a colum, of the table and all of the rest are measures

how can i remove them? the 3 total columns

  • Anonymous wrap your measures with:

    If(HASONEVALUE('Table'[Code_Article], [Measure]).

    It will blank the totals

2 Replies

  • SpartaBI's avatar
    SpartaBI
    Icon for Community Champion rankCommunity Champion

    Anonymous wrap your measures with:

    If(HASONEVALUE('Table'[Code_Article], [Measure]).

    It will blank the totals

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks alot it work perfectly 🙂