Forum Discussion

Vamshi_PBI's avatar
Vamshi_PBI
Frequent Visitor
2 years ago

Help with DAX ALLSelected

Hi Team,   I need some help with writing dax formula. PFB details.   My data model is having 2 tables and the data modelling as below . My datasource is a combination of live and direct query.  ...
Need Help
Daniel29195's avatar
Daniel29195
Community Champion
2 years ago

Vamshi_PBI 

All Amount = CALCULATE(SUM(FactSales[Amount]),ALLSELECTED(dimproduct[productname]))

 

 

 

 

If this answers your question  ,  mark it as the solution āœ… so can you can help  other people in the community find it easily .

Vamshi_PBI's avatar
Vamshi_PBI
Frequent Visitor
2 years ago

Hi Daniel29195 ,

 

With this approach , cross join wont happen, but total sum (for selected products or all products) is not reflected for all rows. 

 

 

Thanks.

  • Daniel29195's avatar
    Daniel29195
    Community Champion
    2 years ago

    Vamshi_PBI 

    if you are intending of using all the product columns into the visual : 

    All Amount = CALCULATE(SUM(FactSales[Amount]),ALLSELECTED(dimproduct))

     

     

    • Vamshi_PBI's avatar
      Vamshi_PBI
      Frequent Visitor
      2 years ago

      Hi Daniel29195 , Sorry for the late response.

       

      This still resulting in cross join and total value is also not diplayed againist each row.

       

       

      Thanks.

      • Daniel29195's avatar
        Daniel29195
        Community Champion
        2 years ago

        Vamshi_PBI 

        please if possible, share the file so i can take a closer look at the issue . ( via google drive or dropbox)

         

        best regards