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.

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.