Forum Discussion

rcister's avatar
rcister
Frequent Visitor
5 years ago
Solved

rocio

Hello. I need help  I have the following table    the column Count represents is one because it represents each row of overnight stays. I need to sum the Count column and be able to filter ...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi rcister,

     

    You can create measure as:

    Measure = 
CALCULATE(
    SUM（'Table'[Count],
    ALL('Table')
)

    Then you can apply the date slicer.

     

     

    Best Regards,
    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

dkaushik's avatar
dkaushik
Resolver II
5 years ago

Hi rcister ,

 

Are you trying to do it in power bi or excel? If power bi, then create a measure like this:
Sum of Count = CALCULATE(SUM('Table'[Count])). Then create a table visual and put your timestamp and this measure in.

 

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

 

Thanks,

Dheeraj

rcister's avatar
rcister
Frequent Visitor
5 years ago

the source is from a excel , but i'm working power bi, this table is related with a master calendar, with the relation bwt calendar[datekey] ( represent a key for one unique date) and table [datekey] ( represent the key for overnigth date)

 

 

 

  • dkaushik's avatar
    dkaushik
    Resolver II
    5 years ago

    Okay. Then, the above solution should work.