Forum Discussion

SA800029's avatar
SA800029
New Member
7 years ago

Slicer parameter in DAX

Hi,   I'm trying to add a calculated column to a table with a simple formula based on a parameter and a slicer.   My parameter is a simple interger ranging from 70000 to 70999, it represents airc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

Sorry for answering late, our company has switched account, I had to create a new one, anyway.

Thank you for your advices, I see that my problem wasn't clear. I don't have any trouble filtering the table using a measure, what I need to do is to use this measure to filter my model.
Greg, your formula works fine, but it only applies a visual filter on my table.

Do you think it's possible ?

Here's a picture of (part) of the model if it helps :
"Table Avions" is the parameter used in the slicer
"MSN Effectivity" is the table I've been trying to add the calcultaed column / measure to filter the rest of my model

 

Thank you,

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

     

    For those of you who would encounter the same problem I found a way to get around my problem.

    I had to change the table "MSN Effectity" : instead of having a table with : Key / Min range / Max Range, I've duplicated the lines (Key) for each MSN, so I end up with : Key / MSN (where Key "i" is repeated "n" times, "n" being the difference between Min Range and Max Range for the specified Key).

     

    I plugged my column "MSN" to a slicer and it work perfectly.

     

    Thank you for your support and happy new year,