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 

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