Forum Discussion
Calculate with filter
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:
Latest Value =CALCULATE(SUM(SPE[Value]),SPE[Latest In Group]="Latest")
Once you use slicer, it will behave the way you want.
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:
Once you use slicer, it will behave the way you want.