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")

amitchandak's avatar
amitchandak
Super User
6 years ago

BlueNoze , Try like

sumx(Table, switch(true(),Table[Hire Status] = "Unpaid",Table[HAccountTotal],
						Table[RepairStatus] = "Unpaid",Table[RAccountTotal],
						Table[RandSStatus]= "Unpaid" ,Table[RSTotal],blank()))