Forum Discussion

Drooopy's avatar
Drooopy
Regular Visitor
2 years ago
Solved

Filtrage des dynamique des rapports

Bonjour,   Je débute avec power BI; j'ai une table de référence qui contient des intervales de dates; c'est des données de périodes. Exemple Campagne 1, de 2020 à 2030, Campagne 2, de 2022 à 2032, ...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Drooopy ,

    You can create a measure as below to get it, please find the details in the attachment.

    Sum of value = 
VAR _selcamps =
    ALLSELECTED ( 'Table'[Campaign] )
VAR _syears =
    CALCULATETABLE (
        VALUES ( 'Table'[Start] ),
        FILTER ( 'Table', 'Table'[Campaign] in _selcamps )
    )
VAR _eyears =
    CALCULATETABLE (
        VALUES ( 'Table'[End] ),
        FILTER ( 'Table', 'Table'[Campaign] in _selcamps )
    )
RETURN   
    CALCULATE (
        SUM ( 'Data'[Value] ),
        FILTER (  'Data' , 'Data'[Year] in _syears ||'Data'[Year] in _eyears )
    )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Drooopy ,

You can create a measure as below to get it, please find the details in the attachment.

Count of years = 
VAR _selcamp =
    SELECTEDVALUE ( 'Table'[Campaign] )
RETURN
    CALCULATE (
        MAX ( 'Table'[End] ) - MAX ( 'Table'[Start] ),
        FILTER ( 'Table', 'Table'[Campaign] = _selcamp )
    )

Best Regards