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

 

 

 

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

     

4 Replies

  • 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

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

      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

        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.