Forum Discussion
Total Bar in Funnel Graph
- 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.
- Anonymous6 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.
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.
- Anonymous6 years agoNot applicable