Forum Discussion

shahrukhgaffar0's avatar
shahrukhgaffar0
Regular Visitor
1 year ago
Solved

Dax issue need help in dax

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_...
"DAX "
"DAX " "DAX help" 'Need help'
  • bhanu_gautam's avatar
    bhanu_gautam
    1 year ago

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

     

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

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's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

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.