Forum Discussion

noneother's avatar
noneother
Frequent Visitor
4 years ago

Using a DAX measure in a table visualisation to return the same scalar value in a new column

Hello   I want to use a DAX measure (not a calculated column) as a fourth column (outlined in red, below) within a table visualisation.  However, my DAX only returns the single row:   DAX =...
smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

noneother  does this work?

CALCULATE (
    MIN('Status'[Status])
    ,'Status'[Status group] = "Final"
    ,'Status'[Status] = "Disposed"
)
  • noneother's avatar
    noneother
    Frequent Visitor
    4 years ago

    That works but I introduces redundant rows, creating way more than the original 5 rows for Type ID: AEG3ML

    • smpa01's avatar
      smpa01
      Icon for Community Champion rankCommunity Champion
      4 years ago

      noneother  is it kindly possible to provide a sample pbix please?