Forum Discussion
Slicer DAX
Hi,
Consider I have a sql table as below:
| Item | ID | Qty | Date |
| TV | 1002 | 3 | 11.03.2021 |
| TV | 1003 | 4 | 12.03.2021 |
| TV | 1004 | 5 | 13.03.2021 |
In PowerBI, I want to show the table with sum of qty of the item and max date of the item along with ID as a slicer:
when no selection is made on the slicer, the below must be displayed:
| Item | Qty | Date |
| TV | 12 | 13.03.2021 |
when I choose the ID as 1003 in the slicer, the table should get filtered for that particular ID and display the date like below:
| Item | Qty | Date |
| TV | 4 | 12.03.2021 |
Need help in deriving the date based on the slicer selection,
Thanks in advance.
1 Reply
- Jihwan_Kim
Super User
Hi, AishwaryaS
Please check the below picture and the sample pbix file's link down below, whether it is what you are looking for.
All measures are in the sample pbix file.
https://www.dropbox.com/s/gghyqqcgvltdb9w/aishwaryaS.pbix?dl=0
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
