Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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] ))
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.
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
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] ))
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
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!
Hi @Anonymous ,
Based on all my research, It not able to remove the column header there.
Hi @Anonymous ,
The [ClientSOH] and [Sellthrough] are both columns? rather than measure?
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |