Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to filter only specific column in table

Hi everyone, I'm working on a table, and I need to filter a data of specified range time in table. But not all the column, just a specific column. All the remaining column must keep current value.  ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous 

    Sorry that I did not clearly understand from the first time.

    I hope this time I understood correctly.

    The new link is down below.

     

    Hour by Date V2 =

    CALCULATE (
    SUMX (
    Query1,
    Query1[Hours]
    ),
    FILTER (
    Query1,
    SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]
    )
    )
     
     
     
    Cost by Date V2 =

    CALCULATE (
    SUMX (
    Query1,
    Query1[CostValue]
    ),
    FILTER (
    Query1,
    SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]
    )
    )
     
     
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello, 
yah thank you so much,


Hour by Date, just show the cost in the date of range
I mean.
I want to show Hour for all of time, and Hour by date => hour by specified date( slicer). But just when select slicer , only 2 columns has been refreshed, total value is not allowed to refreshed.

Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
5 years ago

Hi, Anonymous 

Sorry that I did not clearly understand from the first time.

I hope this time I understood correctly.

The new link is down below.

 

Hour by Date V2 =

CALCULATE (
SUMX (
Query1,
Query1[Hours]
),
FILTER (
Query1,
SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]
)
)
 
 
 
Cost by Date V2 =

CALCULATE (
SUMX (
Query1,
Query1[CostValue]
),
FILTER (
Query1,
SELECTEDVALUE ( 'Table'[ClientId] ) = Query1[ClientId]
)
)