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 how to do 🙂 but it needs to calculate the sum of the 3 columns;

 

"HAccountTotal" (When "Hire Status" = "Unpaid") + "RAccountTotal" (When "RepairStatus" = "Unpaid") + "RSTotal" (When "RandSStatus" = "Unpaid")

 

Hope this makes sense. Thanks

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

3 Replies

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

  • 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()))