but having a slicer in the page to filter out currency types is not an option.
I've thought of having the slicer hidden in the page with all currency types selected but unfortunetly when more than 1 is selected it defaults all of them to USD.
2. Calculated column in summarized table and sort by sell price then change aggregation in value field to last. (This gave incorrect results when it came to blank products. This also is not the ideal solution to begin with.
I want to avoid using calculated columns in the fact table as it is millions of rows in size.
Sometimes Currency Types shows up as blank() so I would need it to default to USD in the Matrix what happens.
Possible currency types are (USD, MXN,CAD,BLR)
My intended results are depicted below in Image 2
Fact Table columns shown in Image 3
Relationship between Dim Products and Fact Table showin in Image 4
Reaching out to the best in hopes of some DAX wizardry @Greg_Deckler