Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Prevent spliting when using LYTD (pbix attached)

I have this pbix : https://drive.google.com/file/d/1tpGKvL_ST1L7YgDkDFqqLqfKb0FEjfcL/view?usp=sharing   I have a single selection filter on Year, and when I select 2021:     My goal is to ...
Need Help
BeaBF's avatar
BeaBF
Icon for Super User rankSuper User
5 years ago

Anonymous If you want to see all the totals only on the "Local" type, why do you put the other types in key?

The purpose of your request is not clear to me.

Could you show the expected result and what you fail to do?

 

B.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks for your answer BeaBF ,

 

My expected output is:

(when 2021 is selected):

 

 

When 2020 is selected... it should work as it is already working:

 

  • PaulOlding's avatar
    PaulOlding
    Icon for Solution Sage rankSolution Sage
    5 years ago

    This measure gets your example result.

    It first builds a table of Revenue LYTD for each inscope customer ignoring Type, then aggregates for the final result.

     

    Net Revenue LYTD = 
VAR _CustomerLYTD = 
ADDCOLUMNS(
    VALUES(Revenue[Customer]),
    "@LYTD", CALCULATE([Net Revenue YTD], SAMEPERIODLASTYEAR('Date'[Date]), REMOVEFILTERS('Type') )
)
VAR _Result = SUMX(_CustomerLYTD, [@LYTD])
RETURN
    _Result