Forum Discussion

BlueNoze's avatar
BlueNoze
New Member
6 years ago
Solved

Making a Total of Multiple Columns Using Multiple Filters

Hi All   I have tried searching for the answer to this but cant seem to find the answer plus im very new to BI so appareciate your patience.   So I needs to add a card visualisation (which i know...
Need Help
  • DataZoe's avatar
    DataZoe
    6 years ago

    Hi BlueNoze ,

     

    Please try this as a measure:

     

    YourMeasure =

    calculate(sum(TableName[HAccountTotal]),TableName[Hire Status] = "Unpaid")

    + calculate(sum(TableName[RAccountTotal]),TableName[RepairStatus] = "Unpaid")

    + calculate(sum(TableName[RSTotal]),TableName[RandSStatus]= "Unpaid")

DataZoe's avatar
DataZoe
Microsoft Employee
6 years ago

Hi BlueNoze ,

 

Please try this as a measure:

 

YourMeasure =

calculate(sum(TableName[HAccountTotal]),TableName[Hire Status] = "Unpaid")

+ calculate(sum(TableName[RAccountTotal]),TableName[RepairStatus] = "Unpaid")

+ calculate(sum(TableName[RSTotal]),TableName[RandSStatus]= "Unpaid")

BlueNoze's avatar
BlueNoze
New Member
6 years ago

Worked Perfectly Thanks!