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
Super 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]
)
)
 
 
    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, Anonymous 

      Thank you for your feedback.

      I am not sure if I understand your question correctly.

      I assume that your question is. if you select nothing in the bottom slicer, the up-table Avgcost / Avghour result is empty, right??

      In this case, you have to change the measures. Because it depends on the selection from the slicer. If nothing is selected, then the calculation will be nothing. 

      I don't know very well about your data, but I am allowed to suggest, please try to create the dim-table for your slicer. And change the measures.

      Please check the below link.

       

      https://www.dropbox.com/s/qjrbzivuas1ef65/testdata.pbix?dl=0 

       

       

      • 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.