Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic formula based on corresponding column

Hi everyone,   I have the following formula: United Measure = VAR SelectedColumn = SELECTEDVALUE('C'[C])   Return SWITCH(SelectedColumn; "C1"; SUMX('E&A';'E&A'[Hours]*RELATED('A&C'[C1])); "C2...
Need Help
parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous can you share sample pbix file with expected output and can look at it. It is bit hard to understand and reproduce the dataset from your post.