Forum Discussion

MrNoob's avatar
MrNoob
Helper II
7 years ago

All / slicer issue, discards data

Having an issue, so i work for an airline, and trying to take the sum of all passengers (Industry PAX), my formula works at the macro level, but when you get down to specific markets it starts to mes...
Need Help
MrNoob's avatar
MrNoob
Helper II
7 years ago

Hello all, 

 

Thank you for the replies,  I have created a sample data set and recreated the issue, i am wishing to correct.  I need the IND PAX number to not change when selecting the different carriers.  

 

 

 

 

https://1drv.ms/u/s!Aga7ypCzQZ2yjl4yxphW0knm-YQ2

parry2k's avatar
parry2k
Super User
7 years ago

MrNoob whcih slicer on this sample report refers to different carriers?

  • MrNoob's avatar
    MrNoob
    Helper II
    7 years ago

    I am sorry, it is the slicer that is label Mktg_carr_cd.  It has 2 letters like AC, UA, LH and so on listed in it.

  • MattAllington's avatar
    MattAllington
    Community Champion
    7 years ago

    MrNoob thanks for providing the data.  I am with v-juanli-msft above although I have no issue with realistic data (actually I think this is better).  What you have provided is not a good approach, especially in this case.  This is a non-trivial problem to be solved.  There is not 1 easy magic formula that you are overlooking - it is a complex problem that will require good table design as well as (likely) some tricky DAX.  To solve the issue, you will need to set up tables like specified by v-juanli-msft above.  You will also need to set up a matrix showing what your formula does now, and what numbers you expect to see.  It is often useful to show a working example in Excel to clearly desccribe the problem.  You know what you want but we don't, so you need to help us help you.