Forum Discussion
Ritaf
Responsive Resident
Responsive Residentsummarise measures
Hi , i made a report for monitoring rebates for purchase. We get Rebate from supllier , by purchasing products of special manifacturers. every manigacturer have his target and rebate. We getting a ...
The product documentation covers the basics https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
And the following article might also be of interest https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
d_gosbell
Super User
Super UserCool, that's the exact approach I was thinking of when I said "a crossjoin of the values of the keys from the 3 different dimension tables, then do a SUMX over that derived table". I'm glad you found a solution.
RitafResponsive Resident
Responsive Residentthanks a lot, can you recomnd me some materials to read / to see about cross join with dax?
- d_gosbell
The product documentation covers the basics https://docs.microsoft.com/en-us/dax/crossjoin-function-dax
And the following article might also be of interest https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/