Forum Discussion

Andrei_Butov's avatar
Andrei_Butov
Regular Visitor
2 years ago

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 ...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Andrei_Butov ,

Create a DAX measure to conditionally display the planned revenue values only at the desired hierarchy levels. You can use the function ISINSCOPE to determine the current level of the hierarchy being displayed and conditionally return the planned revenue or a blank value.

Display Plan = 
IF(
    ISINSCOPE('DateTable'[Date]) && ISINSCOPE('DepartmentTable'[Department]),
    SUM('PlanTable'[Planned Revenue]),
    BLANK()
)

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.

Andrei_Butov's avatar
Andrei_Butov
Regular Visitor
2 years ago

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 ||

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.