Hi there,
I have the following data that I am filtering buy a Value_date. I only want to show the deal id if it's last value date is equal to the last date specified in the filter.
AA Last value date is a measure with
The link provided explains it quite well, I think, but if that is not enough I would need a sample pbix (mock or real data) and I can build it for you. That'd probably be easier to follow than trying to explain here.
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
You can share the URL to the file hosted elsewhere: Dropbox, Onedrive... or just upload the file to a site like tinyupload.com (no sign-up required).
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
1. Create this measure:
Show Measure =
VAR isLast_ =
SELECTEDVALUE(data021_forum__2[AA Last value date]) =
CALCULATE(MAX(data021_forum__2[AA Last value date]),ALLEXCEPT(data021_forum__2,data021_forum__2[ShortName], data021_forum__2[DealType]))
RETURN
IF(isLast_, 1, 0)
It assumes you want to look at date by ShirtName and DealType. If you want the latest date per only ShirtName it needs only ShortName in the ALLEXCEPT():
Show Measure =
VAR isLast_ =
SELECTEDVALUE(data021_forum__2[AA Last value date]) =
CALCULATE(MAX(data021_forum__2[AA Last value date]),ALLEXCEPT(data021_forum__2,data021_forum__2[ShortName]))
RETURN
IF(isLast_, 1, 0)
2. Select the visual and place the measure in the visual filters. Select to show when value of the measure is 1
3. See it all at play in the attached file
4. I would recommend to have a proper date table and use it for filtering instead of using the date columns in your main/fact table. I would also recommend not to use the data hierarchy feature and use the date table instead (https://community.powerbi.com/t5/Desktop/How-to-remove-Date-Hierarchy/td-p/647711)
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Perhaps there's some restriction with SELECTEDVALUE() in the environment you are using? Try this:
aa Show Measure =
VAR isLast_ =
IF (
HASONEVALUE ( InterestAccrual[ValueDate_Date] ),
VALUES ( InterestAccrual[ValueDate_Date] )
)
= CALCULATE (
MAX ( InterestAccrual[ValueDate_Date] ),
ALLEXCEPT ( Subsidiary, Subsidiary[ShortName] )
)
RETURN
IF ( isLast_, 1, 0 )
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @aib
It is just showing zeros for all items.
this is the measure I used:
Hi @Annemie19
You can create a measure that returns a 1 when the rows is to be shown and a zero when it isn't. then use that measure as filter for the visual, showing values whne the measure is 1.
Check this out for further info: https://www.sqlbi.com/articles/applying-a-measure-filter-in-power-bi/
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
