Show one value based on column headers and one separate

[Anonymous]

Hello,

I'm trying to show one of my values as a total ONLY and one based per month. Here is a screenshot of what I currently have:

I would only like to see SellThrough based on the month. The ClientSOH is actually a duplicate value and I'd only like to display it as a single column. Not based on the month. The reason for this is because the data only displays the latest ClientSOH. 

Thanks in advance.

[v-diye-msft]

Hi @Anonymous 

We can create a measure using DAX like this to show the total sales of every month, and another measure to show the total of all month.

TotalSalesByMonth = CALCULATE(SUM(Sales[Sellthrough]),ALL(Sales[ProductDescription]),VALUES(Sales[Month]))

Pbix attached.

[Anonymous]

Hi,

I don't need the total sales. The sales must stay how they are. I need the ClientSOH to be just one column instead of per month. So if I put:

TotalClientSOH = CALCULATE(SUM('Sell Out'[ClientSOH]),ALL('Sell Out'[ProductDescription]),VALUES('Sell Out'[Month]))

and put it under values, it's giving me the following:

The ClientSOH for the "Amplify New Revolutionary earphones - Black & Blue" should be in a single column and the value should only be 897

Thanks

[v-diye-msft · Accepted solution]

Hi ,

The best we can do is replacing the ClientSOH with below measure, but note that the column name will always appeared.

MeasureofCilentOH = 
    
        IF(ISINSCOPE(Sales[Month]), BLANK(),
            SUM(Sales[ClientSOH]
        )/DISTINCTCOUNT(Sales[Month]
    ))

[Anonymous]

Hi,

Thanks I'll try the measure. If I create a measure for total sales as well, as you mentioned above, will the headings per month for the ClientSOH not be there?

Thanks

Pete

[v-diye-msft]

Hi @Anonymous 

Could you tell me if your problem has been solved? if so, please kindly mark the most helpful answer as solution to help others find it more quickly. thanks a lot!

[v-diye-msft]

Hi @Anonymous ,

Based on all my research, It not able to remove the column header there. 

[v-diye-msft]

Hi @Anonymous ,

The [ClientSOH] and [Sellthrough] are both columns? rather than measure?