Exclude columns from slicer

[Anonymous]

Hi everyone, 

I'm trynig to exclude some columns from a slicer.

In my slicer, I put the months of the year and in my report, some data for my company. I want some of them to be affected by the slicer ("volume 24" and "VRD H acc 24", but I also want some of them to stay static ("stocks volume 24" and "valeur 24 stocks").

Most of these columns are measures.

Is it possible ? Can someone help me please ? 🙂

Thanks !!!

[lucadelicio · Accepted solution]

was a refuse from an example, you have to remove it.
How is calculated Stock 24?
Can you pos the relation of the table?

[lucadelicio]

You have some problem on the model.

The fact table will be only one with the date as column

2023
UNION
2024

Column1 - Col2 - Col3 - DateColumn

1. Add a date column 01/01/2023 on the 2023 table

2. Add a date column 01/01/2024 on the 2024 table
3. Append your table to a fact table to use in the model

The relationship will be only SINGLE WAY and not BOTH if is not strictly necessary.

In most case it will be 1 to many relationship.
If you mantain BOTH when you filter something the propagation it will be on both the table of the relationship. Remove the inactive relationship if you don't use it.

[Anonymous]

It does not work if I do not put the both way relationships, all the date are the same for the different rows.

I added the date column in 2023 and 2024, my relationship are based on the item number

[Arul · Accepted solution]

@Anonymous ,

stocks volume 24 Ignore Month = 
CALCULATE(
    [stocks volume 24],
    ALL('Date'[Month]))

valeur 24 stocks Ignore Month = 
CALCULATE(
    [valeur 24 stocks],
    ALL('Date'[Month]))

If you don't have a separate date dimension table, then replace 'Date' with your actual table name where the month slicer values are being pulled from.

[Anonymous]

I tried it, as you can see in my previous comments, but it doesn't work 😞 

[Anonymous]

Thank you, I will try it !

In your example, you add Customer[Continent] as an example, I'm not sure what I should put in my case ? 

[lucadelicio · Accepted solution]

was a refuse from an example, you have to remove it.
How is calculated Stock 24?
Can you pos the relation of the table?

[lucadelicio]

Hi @Anonymous 
you can write the measure using all the values of the date table that is connected with the fact table.
Somenthing like this:

UsingAllValues=
CALCULATE (
    [stocks volume 24],
    ALL ( Date ),
    VALUES ( Customer[Continent] )
)

[Anonymous]

My posting date is in the table CINOCO (so I use it for my slicer), this table is also used for the data of "Volume 24" and "VRD H ACC 24". 

The data is linked to the tables 2024 and 2023 by a unique item nummer. In the table 2024 you can find the data for stocks volume 24

Hope it is clear 🙂 and a big thank you for your help

[Anonymous]

I tried it without the "VALUES" part, and it doesn't work, as it shows the same amount for "Mesure" and "Stocks VOL 24"