Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello PBI Community,
I've been trying to solve an issue where I have a true/false measure that will indicate when a team will reach a certain benchmark.
In this first image, you can see the Forecast date, Optimistic date, and Pessimistic date cards on the top right which correlate to the table Estimated Points value and when a team reaches that point. If the two concerned columns match, we get a 1 to show up. Now the multi-row cards on top have been filtered to show only the dates that meet this condition. The issue is that it doesn't show just the first day the condition is met. We would rather not have it scroll.
Expanding the card for clarity.
If I make the visual a single value card showing the earliest date, the card is populated with the first date in the table, rather than the first to meet the condition.
Even when filtered for only the dates that meet the condition.
I've made a few posts about this issue, and this is hopefully much clearer than I have explained previously.
Thank you in advance.
Solved! Go to Solution.
Solved it!
this is the DAX needed to find my first non-blank date for each column.
First I had to change the original DAX to produce a blank for false and this worked perfectly.
Proof:
Hi @DAXtheDestroyer ,
Create 3 measures with the code below, changing the reference for IsMetForecastIndicator, ISMetOpFore, and IsMetPESFore respectively.
Example measure for IsMetForecastIndicator.
IsMetForecastIndicatorCard = CALCULATE(min('Table'[Date]),'Table'[IsMetForecastIndicator]=1)
This should take the earliest date that has an "IsMetForecastIndicator" value of 1.
Once you created the 3 measures, convert them into single value cards.
Screenshot of Output:
Thank you for helping me out. Unfortunately, that produced an "A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter" error. I was able to get around it by changing the DAX a bit:
But I still get the wrong date to populate. It is reverting to the earliest date in the date filter in the upper left corner:
Solved it!
this is the DAX needed to find my first non-blank date for each column.
First I had to change the original DAX to produce a blank for false and this worked perfectly.
Proof: