Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Total Bar in Funnel Graph

HI All, I added the total Bar line in the Funnel graph where my requirements are: 1-. To show the total bar 2. Based on the selection from the dropdown the total bar line value should also change....
  • parry2k's avatar
    6 years ago

    Anonymous change your calculated table expression as below

     

    Table 6 = UNION(SUMMARIZE('Table (5)',"ACC","Tota1","AD", "Total","Aging","TotalS","P",0),'Table (5)')

     

    Add new measure to show in funnel graph

     

    Total Aging = IF ( MAX ( 'Table 6'[Aging] ) = "TotalS", CALCULATE( SUM ( 'Table 6'[P] ), ALLSELECTED() ), SUM ( 'Table 6'[P] ) )

     

    Use this measure Total Aging in the visual and it will give you what you are looking for.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Anonymous ,

    I just modified table 6 as below
    Table 6 = UNION(SUMMARIZECOLUMNS('Table (5)'[Aging]),SUMMARIZECOLUMNS('Table (5)',"Aging","Totals"))

    After that create inactive relationship using Aging (Fig 1.1).

    Aging filter from table 5 and create the below measure to achieve the request 
    Value = IF(SELECTEDVALUE('Table 6'[Aging])="Totals",CALCULATE(SUM('Table (5)'[Tot]),ALLSELECTED('Table (5)')),

    CALCULATE(SUM('Table (5)'[Tot]),USERELATIONSHIP('Table (5)'[Aging],'Table 6'[Aging])))

     

    Fig 1.1:

    Output:



     


    Best Regards,
    Mail2inba4

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.