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.
Hi,
i've a measure defined like this:
The "Previous" term means SEASON - 10.
Now, if i want to add another detail level, like the Month, this is what i got:
The Measure won't split by month, i get the total instead.
Is there a way to use the Caculate function with the filter clause, but in the sametime maintain the context of the table ( or visual)
where the Measure is placed?
Thanks in advance for help,
Best Regards
--D
Solved! Go to Solution.
Hi @LJAdmin ,
Try to modify your measure as below:
T_QTA_VENDUTA_SP = CALCULATE(SUM(DM_RETAIL_PRODUCTS[QTA_VENDUTO]),FILTER(ALL(DM_RETAIL_PRODUCTS),DM_RETAIL_PRODUCTS[STAGIONE_VENDITA]=MAX(DM_RETAIL_PRODUCTS[STAGIONE_VENDITA])+10))
If the above doesnt work,could you pls upload your .pbix file to onedrive and share the link with us?Remember to remove the confidentail information.
Hi @LJAdmin ,
Try to modify your measure as below:
T_QTA_VENDUTA_SP = CALCULATE(SUM(DM_RETAIL_PRODUCTS[QTA_VENDUTO]),FILTER(ALL(DM_RETAIL_PRODUCTS),DM_RETAIL_PRODUCTS[STAGIONE_VENDITA]=MAX(DM_RETAIL_PRODUCTS[STAGIONE_VENDITA])+10))
If the above doesnt work,could you pls upload your .pbix file to onedrive and share the link with us?Remember to remove the confidentail information.
@LJAdmin , You can create rank for the session. and Use that. But create a separate session table
This Session = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Session Rank]=max('Date'[Session Rank])))
Last Session = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Session Rank]=max('Date'[Session Rank])-1))
Something very smiliar to
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Use something like this:
=
CALCULATE ( [Total Sales], DATEADD ( Dates[Date], -10, MONTH ) )
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 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |