topic Dax issue need help in dax in DAX Commands and Tips

Dax issue need help in dax

shahrukhgaffar0 — Thu, 28 Aug 2025 21:04:43 GMT

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)

Re: Dax issue need help in dax

bhanu_gautam — Fri, 29 Aug 2025 07:34:44 GMT

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).

Re: Dax issue need help in dax

v-lgarikapat — Mon, 01 Sep 2025 06:59:52 GMT

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.

Re: Dax issue need help in dax

v-lgarikapat — Thu, 04 Sep 2025 12:34:17 GMT

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.

Re: Dax issue need help in dax

v-lgarikapat — Mon, 08 Sep 2025 06:46:07 GMT

Hi @shahrukhgaffar0 ,

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

Best Regards,
Lakshmi.