Forum Discussion

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

Dealing with Measure Totals

This one has come up quite a bit recently. The issue surrounds using Measures in Table visualizations with a Total row. The complaint is that the "Total" row is "wrong" for the measure. Technically, ...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi, My problem statement is a little different. Below is my table.

Name            forecast   capacity  Leaves               Availability                            Answer column

Abc                   33             37          0          if(37-33-0 < 0, 0, 37-33-0)                       4

efg                    42             37          8          if(37-42-8 < 0, 0, 37-42-8)                       0

Total to get                                                                                                                  4

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

    Do these measures work?

    Availability inter = if([capacity]-[forecast]-[leaves]<0,0,[capacity]-[forecast]-[leaves])

    Availability = SUMX(VALUES(Data[Name]),[Availabiliy inter])

    Drag the Availability measure to your visual.  My assuption is that capacity, forecast and leaves are measures that you have already written.