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

yah, thanks for your advice. Your file is an example right?
https://www.dropbox.com/s/qjrbzivuas1ef65/testdata.pbix?dl=0 

 

In my file, when I select seperate date, it works fine now. But if I select all of dates. The measures are empty. Do you know the issue, do I need to add any filter. 

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 
thank you for your feedback.

I am not sure, but in my opinion, try to check what does "selectedvalue( )" bring you for the result. 

It is a very useful function.

However, if there is more than one value selected, then the outcome is blank.

I saw in the measures that quite a lot of selectedvalue()  are used. 

So, if your slicer is selecting more than one, then the result is blank. 

I hope it helped.

 

Adding a filter and write a measure simply is one way.

 

However, I am not sure if there are some reasons why you prefer not to connect the tables, and use selectedvalues()

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank so much for your information, I don't connect to table, because  I want to show all the value even it's empty.  😞