Forum Discussion
DAX Table for Funnel chart
I’m trying to create a Funnel Chart. I’m looking to sum all the funding sources for a project to create grand total that I can use at the top of a funnel chart.
I would like to create a table using DAX that returns the following table with an additional row with the grand total.
Funding source Name
Funding Amount
Here is a diagram of my data.
I tried to follow this sample, but I think I need to relate DimFunding in some way.
Table = UNION(SUMMARIZE(Table1,"Product","Total","Quantity",SUM(Table1[Quantity])),Table1)
2 Replies
leekohr , In power query on FactProjectTab use merge query Connect DIM Project and add a funding source
The both dim will now join to FactProjectTab
You can create a measure Sum(FactProjectTab[Funding Amount])
Now create a funnel visual with the funding sources name and the above measure
Merge : https://radacad.com/append-vs-merge-in-power-bi-and-power-queryThanks, I will try that
