Forum Discussion

t0talz's avatar
t0talz
Regular Visitor
8 years ago
Solved

Table with Filtered Measures

Hi,

I'm new to PBI and maybe my issue can be solved by a completely different approach, and a different visualization. However I can't come up with an easy solution to this.

 

I want to have a table with multiple raws and one column (measure).

Here is some sample data (very simplyfied):

page||sessions||date
home|100|2018-01-01
home|80|2018-02-01 sub|150|2018-01-01 cat|200|2018-01-01 bar|50|2018-01-01

Now I want to use table to visualize this data. The measure is "sessions" but the raws should represent filtered values. For example:

 

raw01=(filter page == home) AS "home"

raw02=(filter page == sub OR page == cat) AS "s&c"

 

So my visual should look like this table:

raws||sessions
home|180
s&c|350

I boiled down all complexity to the minimum, in hope to make my question as abstract as possible.

 

My goal is to have filtered values (by multiple conditions) within a table as an overview. Right now I achieve this with multiple tables (every table with its own filter) and custom columns (which are created by a way to complicated R script to return if REGEX criteria is met, since I cant find a way to use AND operator in derived columns and REGEX).

  • Easiest thing to do would to create  calculated column with an IF or SWITCH statement that spits out the actual text that you want and then just put that column in a table with your measure.

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Easiest thing to do would to create  calculated column with an IF or SWITCH statement that spits out the actual text that you want and then just put that column in a table with your measure.