YTD Sales Measure

Question

Hello,&nbsp;I am using category segmentation here. When I apply the measure at the category level, the YTD CY Sale measure is working fine. However, when I apply the same measure at the customer level, it shows the same total for all customers. Can you please help me fix this?&nbsp;&nbsp;Following is my measure:&nbsp;&nbsp;YTD Sales = TOTALYTD([Total Sale],'Calendar'[Date])&nbsp;YTD CY Sale =&nbsp;CALCULATE (&nbsp; &nbsp; [YTD Sales], &nbsp; &nbsp;&nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; ALL ( invoices_details[customer_no] ),&nbsp; &nbsp; &nbsp; &nbsp; COUNTROWS (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FILTER (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'category',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [YTD Sales] &gt;= 'category'[category min value]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;&amp; [YTD Sales] &lt; 'category'[category max value]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; ) &gt; 0 &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; ))&nbsp;Thank you.

ashish_mathur · Answer

Hi,
Share the download link of the PBI file.

abrar786 · Answer

Hi&nbsp;Ashish_Mathur&nbsp;,Here is a link.&nbsp;Power BI files for help&nbsp;Thank you,Abrar

ashish_mathur · Answer

Hi,
Drag the YTD sale measure to the Table visual.

abrar786 · Answer

Hi&nbsp;Ashish_Mathur&nbsp;,Could you please share the file or specify the measure that you have modified?&nbsp;Thank you.

ashish_mathur · Answer

I have not modified any measure.&nbsp; I just removed the YTD CY sale measure and placed the YTD sale measure in the Table visual.

Forum Discussion

YTD Sales Measure

7 Replies

Related content

Previous YTD measure

YTD and YTD PY for multiple measures

How to display sales YTD and sales last YTD over years?

Quartiles based on YTD Sales Measure

YTD measure missing month?