Forum Discussion

Mgg's avatar
Mgg
Icon for Helper I rankHelper I
5 years ago
Solved

Calculate with filter

[ Spoiler ]
  • Migasuke's avatar
    Migasuke
    5 years ago

    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!

  • Migasuke's avatar
    Migasuke
    5 years ago

    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.
Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
5 years ago

Hi Mgg ,
That depends how you trying to visualize the measure or what should be the output.
For example, you can use your measure with Company Slicer and everything will work well.

Mgg's avatar
Mgg
Icon for Helper I rankHelper I
5 years ago

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.

  • Migasuke's avatar
    Migasuke
    Icon for Memorable Member rankMemorable Member
    5 years ago

    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.