Forum Discussion

545's avatar
545
Frequent Visitor
2 years ago
Solved

Count Measure with Filter

i have this measure: # Total_Eng_reports_By_date = VAR x = CALCULATE(DISTINCTCOUNT(qryAssemblyProcessReport[ItemID]), tblStations[StationCode]=28) return IF(ISBLANK(x), 0,x)   the date is set t...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi 545,

    Perhaps You can add variable table with summarize function to calculate the measure formula on the detail level. Then you can summary it's result based on iterator aggregation functions.

    Measure Totals, The Final Word - Microsoft Fabric Community

    Regards,

    Xiaoxin Sheng