Dax issue need help in dax

[shahrukhgaffar0]

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)

[v-lgarikapat]

Hi @shahrukhgaffar0 , 

Thanks for reaching out to the Microsoft fabric community forum.

@bhanu_gautam 

Thanks for your prompt response

@shahrukhgaffar0 ,

I wanted to follow up and confirm whether you’ve had the opportunity to review the information  provided by @bhanu_gautam ,. If you have any questions or need further clarification, please don’t hesitate to reach out.

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @shahrukhgaffar0 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @shahrukhgaffar0 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[bhanu_gautam · Accepted solution]

@shahrukhgaffar0  Try using 

Revenue for Stacked Bar =
VAR SelectedProbs = VALUES(Dim_Win_Prob[Win Probability])
VAR CurrentProb = SELECTEDVALUE(Dim_Win_Prob[Win Probability])
RETURN
IF(
CurrentProb = 100
|| CurrentProb IN SelectedProbs,
CALCULATE(
SUM('Tbl_Revenue'[Revenu_USD]),
'Tbl_Revenue'[Win Probability] = CurrentProb
)
)

Use This Measure in Your Stacked Bar Chart

Axis: Month
Legend: Win Probability
Value: Revenue for Stacked Bar

Slicer on Dim_Win_Prob[Win Probability] (exclude 100 from slicer if you want it always present).