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.