Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Sales_YTD = VAR SD = [StartDate] VAR ED = [EndDate] VAR Result = CALCULATE (
SUM(GMS_View[Value]); FILTER ( ALLEXCEPT (
GMS_View; GMS_View[Brand.Brand Level 01]; GMS_View[Country.Country Level 01]); GMS_View[date] >= SD && GMS_View[date] <= ED )
) RETURN Result
Solved! Go to Solution.
Hi @Ale
I would suggest you modify the ED like below.If it is not your case,please share the .pbix file for us to test. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Sales_YTD = VAR SD = [StartDate] VAR ED = SELECTEDVALUE(Table[Slicer]) VAR Result = CALCULATE ( SUM(GMS_View[Value]); FILTER ( ALLEXCEPT ( GMS_View; GMS_View[Brand.Brand Level 01]; GMS_View[Country.Country Level 01]); GMS_View[date] >= SD && GMS_View[date] <= ED ) ) RETURN Result
Regards,
Cherie
Hi @Ale
I would suggest you modify the ED like below.If it is not your case,please share the .pbix file for us to test. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.
Sales_YTD = VAR SD = [StartDate] VAR ED = SELECTEDVALUE(Table[Slicer]) VAR Result = CALCULATE ( SUM(GMS_View[Value]); FILTER ( ALLEXCEPT ( GMS_View; GMS_View[Brand.Brand Level 01]; GMS_View[Country.Country Level 01]); GMS_View[date] >= SD && GMS_View[date] <= ED ) ) RETURN Result
Regards,
Cherie
Hi @Ale
Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.
Regards,
Cherie
Hmm, that's odd. Sample data would help tremendously. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |