Forum Discussion

Txtcher's avatar
Txtcher
Icon for Helper V rankHelper V
1 year ago
Solved

Field Parameter Contains Field Also Used in Measure

I am still pretty new at Power Bi and am not a professionally trained analyst, so my apologies in advance. I am creating a report to track backlog complaints. The backlog complaint counts are sliced...
  • Txtcher's avatar
    1 year ago

    Thank you for response Anonymous .

     

    I logged on this morning to post that I have solved part of the problem, but now have encountered a new problem.

    This how I solved the bar chart issue:

    1. I created this measure:

    LOF_Backlog Insight = 
    VAR SelectedParameter = SELECTEDVALUE(_LTCR_Dimension_par[Reg-Prog-Priority_par Order])
    Var SelectedInsight = SELECTEDVALUE(_LTCR_Insights_par[_LTCR_Insights_par Order])
    //Determine the parameter values selected. If LOF Insight and Program dimension
    RETURN
    SWITCH(
        TRUE(),
        SelectedParameter = 1 && SelectedInsight = 2,[LOF Backlog by Program],
        [LOF Backlog]
    )

    I put the measure above into the insights parameter and the bar chart works perfectly now. 

    However, now the card visual returns a 0 when selecting both the LOF Backlog and Program parameter values. 

    This a screen shot of the bar chart & card visual (upper left corner). The card visual should not display 0.

    I would willingly share data, but I don't know what data to share that could help solve this issue. 

    In the meantime, I will mark this problem as solved as I did solve the original problem.

    Thank you again to Shahid12523  & FarhanJeelani  for their response.