Forum Discussion

tbezui3's avatar
tbezui3
Frequent Visitor
4 years ago
Solved

Calculation Fixed:MAX

Good day  What can we use in powerbi to get the same result as In tableau when we use the below?  I added a before and after I run the calculation in tableau. I also added a screen shot of the ba...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, tbezui3 ;

    As before:

    we could add matrix visual. then create a hour column.

    hour = HOUR([F2])

    As after:

    We could create a measure to calculate the count.

    Count = CALCULATE(COUNT('Table'[F2]),FILTER('Table',HOUR([F2])=HOUR(MAX([F2]))))

    Then add a table visual.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

tbezui3 ,

calculate(MAX([Calldate]), allexcept(Table, table[uniqueidentifier]) )

 

If uniqueidentifier is from a dimension then also use the table or fact

 

calculate(MAX(fact[Calldate]), allexcept(fact, Dim[uniqueidentifier]) )