cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kissmate Regular Visitor
Regular Visitor

No YTD value when no Actual

Hi All,

 

please help me in this case!

YTD.JPG

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

1 ACCEPTED SOLUTION

Accepted Solutions
kissmate Regular Visitor
Regular Visitor

Re: No YTD value when no Actual

Done it with some relationship change betwwen this and the Date table!

4 REPLIES 4
Community Support Team
Community Support Team

Re: No YTD value when no Actual

Hi @kissmate ,

 

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.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kissmate Regular Visitor
Regular Visitor

Re: No YTD value when no Actual

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

nsrshkh1 Member
Member

Re: No YTD value when no Actual

@kissmate ,

 

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?

kissmate Regular Visitor
Regular Visitor

Re: No YTD value when no Actual

Done it with some relationship change betwwen this and the Date table!

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 49 members 984 guests
Please welcome our newest community members: