Forum Discussion
Show values only at certain levels using Parameter Fields
Hello, I have two fact tables. The first table contains information on sales: revenue, date, department, and other attributes. The second table contains planned revenue values but only for two ...
Hello Anonymous,
your measure show results for all hierarchy levels after [date] and [department]
Main problem: hierarchy levels can be switch
P.S. also your measure show results only for one column [date] and [department] depending on their hierarchy. better to use ||
Hi Andrei_Butov ,
Your idea might be feasible, through || to show the hierarchy.
After trying it, you can share your answers if you can
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.