Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi All,
please help me in this case!
As you can see I calculate actual amount value than YTD value drilled down by customer and item number. As you can see there is only the values where is actual month value (date selector), and it not shows the values for that item numbers when there is no actual amount for that month only just YTD amount. Like the first row, YTD amount is 131 and I'd like to see that YTD values for the item numbers also if it's no actual month data for those item numbers like in this example!
I use the measure like: TOTALYTD(sum(sales'amount');Date'month')
And its working fine until I see it for th customer but after I drill down until item numbers it's like on the picture above!
Many thanks in advance!
Mate
Solved! Go to Solution.
Done it with some relationship change betwwen this and the Date table!
Sorry, could you please let us know what exactly you did with relationships? I have similar problem when ytd (for expl ytd july) amount per client (high level is calculated correctly) but details per item are missing (because this amount consists of items which were done in june and 0 in july).
Done it with some relationship change betwwen this and the Date table!
Hi @Anonymous ,
Could you please share your sample data and excepted result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.
Hi @v-frfei-msft,
unfortunately I can't share my data, but if you have any idea how to show YTD values for a month for the category if there is no actual month data for that category I would be thankful!!
Mate
@Anonymous ,
It is difficult to understand your problem without looking at the data (sample data is also OK, no actual data needed).
how to show YTD values for a month for the category if there is no actual month data for that category
So if there is no actual data available for particular category then how can we see YTD values?
Do you want to show blank line if data is not available instead of not showing that category?
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |