Using a fact table of time and billing records, I wish to add two columns to a table visual from the same dim table. I will be displaying the same description column from the dim table for both columns, but each column will have different filter criteria. In other words, this single dim table is a collection of different types of dimensions such as “hours type”, “region” , or “position”. I want to display one column with “hours type” and another with “position”. There is a unique ID to identify dim records that are “hours type” and a different ID assigned to “position” records.
I am hoping to use a measure to define the filtering but I haven’t been successful. There is no calculation needed, just filtering. I’m sure there’s a completely simple solution I’m not seeing. Thanks.