Calculate rank over dimensions from different tables
Hi PBI Experts,
I have a scenario where I have customer and product dimensions connected to my facts table "Sales" in a star schema. The 2 dimension tables are not related. I want to rank my table like below by descending measure and applying rank on each row of the table.
Main goal : Rank measure based on customer and product combination. My outcome: Rank = RANKX(SUMMARIZE('Sales','Customer'[Customer],'Product'[Product]),[Sales],,DESC,Dense)
Meanwhile, I applied some slicers so that I don't get the error for threshold increase. I have a doubt in the output. My ranking doesn't seem to get update after applying slicer. I sorted the measure DESC in visual but my ranking is not starting from 1,2,3,4 and so on. Its like 0,52 and weird numbers.