Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |