Forum Discussion

PBIViz_2024's avatar
PBIViz_2024
Advocate I
1 year ago

Direct Query-Calculate function-No values

Hi All,

 

I have PBI Dashbaord developed initially using import and I am trying to do the same using Direct query.howver below function works well in import but no values resulting in direct query.

Total Tonnage-Latest =
Var Latest_time=CALCULATE(max(Table1[datetime_val]),all(Table1))
Var _output=CALCULATE(sum(Table1[value]),Table1[datetime_val]=Latest_time,ALLSELECTED(Dimensiontable1[category]))
Return _output
 
Please let me know if any idea on this.
 
Regards,
 
Need Help

2 Replies

Replies have been turned off for this discussion
  • Fowmy's avatar
    Fowmy
    Super User
    1 year ago

    PBIViz_2024 

    You code looks okay, check if any other filters affecting the calcultion on the report. Try to run a Evaluate Table1 in DAX Query View

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi PBIViz_2024 

    Pleasre try the following Dax:

    Total Tonnage-Latest =
VAR Latest_time = CALCULATE(MAXX(ALL(Table1), Table1[datetime_val]))
VAR _output =
CALCULATE(
SUM(Table1[value]),
FILTER(
Table1,
Table1[datetime_val] = Latest_time
),
ALLSELECTED(Dimensiontable1[category])
)
RETURN _output


     

     

     

     

     

    Best Regards,

    Jayleny

     

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