MAXX value is not working in Measure

[farhadidrees]

Hi All,

I have created one measure with below DAX.

I need to find Maximum value against date, but it is only working when i drop Date column in grid.

HeadCount Max =

MAXX(VALUES('Table'[Date]),

     CALCULATE(SUM('Table'[Quantity]),

('Table'[Hours]>=6 && 'Table'[ManualPrice] = 0 && 'Table'[UOM] = "Hours") ||

('Table'[Hours] > 0 && 'Table'[ManualPrice] = 0 && 'Table'[UOM] <> "Hours")||

('Table'[ManualPrice] <> 0 && 'Table'[UOM] = "Hours" && 'Table'[Hours] > 0 )  ||

('Table'[ManualPrice] <> 0 && 'Table'[UOM] <> "Hours" && 'Table'[Hours] > 0 )

,FILTER('Table','Table'[Category] in

{"A","B"})))

I need to place maximum value in Card, not grid. But when i place this in Card so it shows total sum of all dates.

Here is can see 198 Total sum, but i want to show only 18.

Thanks.

[v-rongtiep-msft]

Hi @farhadidrees ,

What is your desired output?  Cound you please provide some sample sample data like you are using in the formula? 

How to Get Your Question Answered Quickly 

Best Regards
Community Support Team _ Polly

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