Forum Discussion
Drill down inherits values, looking for help.
Hi Folks, I'm setting up this Project Performance Dashboad and I have run in to a problem with visaul. In this case I'm using The "Clustered Column Chart" To represent project Costs and Bil...
Hello Anonymous
You can write a mesure that will check what level you are on and when you are at the Cost Group or Employee return blank otherwise return [Total Billed].
Total Billed Filtered = IF ( ISINSCOPE ( TableName[Cost Group Field] ) || ISINSCOPE ( TableName[Employee Enterprise ID Field] ), BLANK(), [Total Billed] )
jdbuchanan71
Super User
Super UserHello Anonymous
You can write a mesure that will check what level you are on and when you are at the Cost Group or Employee return blank otherwise return [Total Billed].
Total Billed Filtered = IF ( ISINSCOPE ( TableName[Cost Group Field] ) || ISINSCOPE ( TableName[Employee Enterprise ID Field] ), BLANK(), [Total Billed] )