Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Filter on visuals causing issues please help

Hello everyone. I am building out a report with visuals for job hours, cost and budget. I have 3 visuals in the report. Invoiced table,Usage table, and Budget hours chart. The data for all of these v...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , In this case Job Number, should be a common dimension and Type should not be. If it is, then you can have a measure that removes the filter of type

 

calculate([measure],removefilters(Type[Type]))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I don't think a measure that removes the filters is going to work. I need to somehow toggle the type based on the invoice table when a job number is selected. I am not sure if this is even possible.

    Thanks Jamie