- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sum based on Date filter for each ID
Hi Team,
Selected Date range March month and expected "Total Prod Val" value 2 NOT 5.
Thanks,
KV's
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , while allexcept should have worked, try one of the two
Total Prod Val = CALCULATE([Prod_Val],filter(ALL('UID'),'UID'[UID] =max('UID'[UID])))
Total Prod Val = CALCULATE([Prod_Val],filter(allselected('UID'),'UID'[UID] =max('UID'[UID])))
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , I not able to see value 3 somehwre , try all or allselected
one of 4
Total Prod Val = CALCULATE([Prod_Val],all('UID'[UID]))
Total Prod Val = CALCULATE([Prod_Val],all('UID'))
Total Prod Val = CALCULATE([Prod_Val],allselected('UID'[UID]))
Total Prod Val = CALCULATE([Prod_Val],allselected('UID'))
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @amitchandak ,
above function are working overall sum, but i'm expected UID wise (sum for same UID)
For example : UID 44.OIU sum is 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Anonymous , while allexcept should have worked, try one of the two
Total Prod Val = CALCULATE([Prod_Val],filter(ALL('UID'),'UID'[UID] =max('UID'[UID])))
Total Prod Val = CALCULATE([Prod_Val],filter(allselected('UID'),'UID'[UID] =max('UID'[UID])))
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
131 | |
79 | |
57 | |
42 | |
41 |
User | Count |
---|---|
209 | |
81 | |
74 | |
58 | |
50 |