Hi Community and Dax Experts,
I am stucked in Between or may be i am not able to Reach at that point.
i have a
Table = Tbl_Revenue
columns = Win Probability,Revenu_USD and Month
In Win_Probability Column we have only 4 Probs
100,90,70,50
so i am using stack bar chart
and legend as Win Probability Column
revenue and Month for Cummilative.
I Have Created Dim_Win_Prob Table
to use in Tbl_Revenue
so i am using Win_Prob[Win Probability] in Slicer and filter by visual Not in 100
so now my filter showing 3 Win probability
90,70,50
so Now i want to calculate
where Everytine it shows 100 Win Probability Revenue
if i select any win Probability from slicer then it append with 100 Win probability
and If i select all three then all three value Append with 100
so my Stack color Will be based on Win Probability and There value as height
Can anyone solve this issue for me
i tried alot but not getting this desire result
i am able to achieve this
but all the time when i use legend it shows equal Value as total for all legend
my calculation
Get Variance Added into Cumulative Target =
VAR REVENUE_100 =
CALCULATE (
SUM ( 'MainTable_ProjectData (2)'[Revenue] ),
REMOVEFILTERS (Dim_Win_Prob[WinProbability] ),
'MainTable_ProjectData (2)'[Win Probability] = 100
)
VAR REVENUE_SELECTED =
CALCULATE (
SUM ( 'MainTable_ProjectData (2)'[Revenue] ),
KEEPFILTERS (Dim_Win_Prob[WinProbability] ),
'MainTable_ProjectData (2)'[Win Probability] <> 100
)
RETURN
IF(ISFILTERED(Dim_Win_Prob[WinProbability]),REVENUE_100 + REVENUE_SELECTED,REVENUE_100)
