Forum Discussion

faldiwan's avatar
faldiwan
Frequent Visitor
2 years ago

ALLSELECTED OR NOT?

Hi all,   I need some help please, I have a simple tabular model. 3 tables Portfolio, Position & Date. The Portfolio table is pretty much a type 1 dimension, Position is a fact table.  The v...
faldiwan's avatar
faldiwan
Frequent Visitor
2 years ago

Hi 

I did CALCULATE( SUM(Amont), Removefilters(InvestmentCode), ALLSELECTED(Company))

Still only returns the amount within the company in the investment

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

    Do not include sensitive information or anything not related to the issue or question.

    If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

    Please show the expected outcome based on the sample data you provided.

    Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

    • faldiwan_ar's avatar
      faldiwan_ar
      Frequent Visitor
      2 years ago

      Position table:

      PortfolioIdTotalValue
      11000
      22000
      33000

       

      Portfolio table:

      IdCompanyInvestment
      1Test1Apple
      2Test2Amazon
      3Test3Arm

       

      Report:

      CompanyInvestmentTotal ValueOverall
      Test1Apple10004000
      Test3Arm30004000

       

      If I use the following day for Overall:
      CALCULATE( SUM(TotalValue), REMOVEFILTERS(Portfolio[Investment]), ALLSELECTED(Portfolio[Company])

       

      I get the Report table above, which is great, BUT if i only select "Investment = A" in the filter "Filters on this visual" I only get Overall = 1000, because it looks like its summing within the selected investments.

       

      Model example:

       

      Works when selecting 2 companies and all investments within the companies.

       

      When then selecting only 1 investment, should expect to see 4000, but shows only value within the 1 investment selected, need to see the 4000