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 October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!