impact, L1_Country ,L2_State ,L3_City
is this possible ?
Go to Solution.
Thanks for your response. this idea worked for me. I made few changes to your formula to restrict blanks at each level.
View solution in original post
@jonnalav , Create a new table
Dim = filter(distinct(union(distinct(Table[L1_Country]), distinct(Table[L2_State]), distinct(Table[L3_City]))),[L1_Country] <> blank())
Join this table (only column- L1_Country) with all three columns
Assume L1_Country to L1_Country is active and others are inactive
Then create a meausre like this and use
sum(Table[impact]) + calculate(sum(Table[impact]), userelationship(dim[L1_Country], Table[L2_State]))
+ calculate(sum(Table[impact]), userelationship(dim[L1_Country], Table[L3_City]))
refer if needed
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.