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.
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.
Thanks Anonymous ,
This is also another solution.
Thanks for your help!
-Tejaswi