Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm in a trouble with a filter.
I need to show a score filtering the data using a measure (not fixed data)
I'm using the following but it doesn't work:
CALCULATE([SpeScore], FILTER(SPE, SPE[Period]=[SpeLastPeriod]))
Anyone can help me?
Thans in advance
Solved! Go to Solution.
Hi,
If I got you right, you trying to calculate SpeScore for latest value.
Unfortunatelly this does not work but there is an easy.
1. In your SPE table, create a calculated column with MAXX and IF, where you specify the latest (period, date, year...)
2. Use your DAX measure, only adjust the condition bit, something like this:
As you can see, I get the value for Period 5, which is the latest.
Please let me know, how did it help!
Hi,
It should work fine, if you use column, which has "Latest" by Company, check this:
The measure then will be a bit adjusted:
GREAT ...problem solved !!!
Many thanks
Hi,
If I got you right, you trying to calculate SpeScore for latest value.
Unfortunatelly this does not work but there is an easy.
1. In your SPE table, create a calculated column with MAXX and IF, where you specify the latest (period, date, year...)
2. Use your DAX measure, only adjust the condition bit, something like this:
As you can see, I get the value for Period 5, which is the latest.
Please let me know, how did it help!
Thanks for your solution but I have an additional complexity: How I can define the "Latest" period taking in consideration also the "Company"?
In the example the latest period for the companies B and D is 2 and NOT 3 like for companies A and C
I'm doind that but its showing always the latest period and so, if the company there isn't in that period (eg Company B period 3) it shoed score "blank.
I'd like to label the latest period x company and not the latest per colum like it is.
Hi,
It should work fine, if you use column, which has "Latest" by Company, check this:
The measure then will be a bit adjusted:
GREAT...problem solved
Thanks for your support.
Now the filter is working well 💪
User | Count |
---|---|
54 | |
22 | |
19 | |
16 | |
11 |
User | Count |
---|---|
81 | |
55 | |
39 | |
20 | |
12 |