Forum Discussion

Sander800's avatar
Sander800
Helper I
9 years ago
Solved

Remove filter in If statement

Hi All,   Hope you can help me out with this one. I am trying to create 2 sets/ groupings of accounts which I want to show in a table in the rows. However the second set is part of the first set hi...
Need Help
Tutorial Requests
  • robofski's avatar
    robofski
    9 years ago

    How about creating two calculated columns:

     

    Total Costs = IF(PL_Blink_Cube[SCOA Level06 ID] = 4500000000, PL_Blink_Cube[Amount],BLANK())

    Some Costs = IF(PL_Blink_Cube[SCOA Level10 ID] = 64405401, PL_Blink_Cube[Amount],BLANK())

     

    This way you keep the rest of the table and have all your relationships.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Sander800,

The only way I can think of is to create a new table using DAX below.

Table 2 = SUMMARIZE(PL_Blink_Cube,"Fixed Expenses",CALCULATE(SUM(PL_Blink_Cube[Amount]),FILTER(PL_Blink_Cube,PL_Blink_Cube[SCOA Level06 ID]=4500000000)),"Some fixed costs",CALCULATE(SUM(PL_Blink_Cube[Amount]),FILTER(PL_Blink_Cube,AND(PL_Blink_Cube[SCOA Level06 ID]=4500000000,PL_Blink_Cube[SCOA Level10 ID]=64405401))))



Regards,
Lydia

Sander800's avatar
Sander800
Helper I
9 years ago

Hi Lydia,

This really is a big step in the right direction.

However this way, of course, I loose al my relations. How can I add (the other) dimensions to this new table?