add bar chart an additional value

[Pikachu-Power]

Hi all,

i have a bar chart and i want to assign to the first of the month a value of 900 for Typ = A, Segment = B and Code = C. My current measure is:

measure_exits =

VAR _begin_month = STARTOFMONTH(Calender[Date])

RETURN

      IF( MAX(Calender[Date]) = _begin_month &&

          MAX(Table[Typ]) = "A" &&

          MAX(Table[Segment]) = "B" &&

          MAX(Table[Code]) = "C", 900, [exicts])

But at the moment i only see the exits and not the 900 😐 Just when i filter Typ = A, Segment = B and Code = C i see the result 900. 

What i want to see are the exits and the 900 for the first of the month when nothing is filtered. When something is filtered i want to see the exicts and in case of Typ = A, Segment = B and Code = C the 900.

Some ideas? Maybe i have to work with SELECTEDVALUE, ALLSELECTED? Somehow out of practise. 

[Pikachu-Power]

I have three slicers at the canvas: Typ, Segment and Code. What i want to see looks like:

Always -900 exits for the first of the months. This -900 is initially just a dummy variable. The meaning doesnt matter. I want to make it dynamic later.

Problem: when i use the measure

measure_exits =

VAR _begin_month = STARTOFMONTH(Calender[Date])

RETURN

      IF( MAX(Calender[Date]) = _begin_month &&

          MAX(Table[Typ]) = "A" &&

          MAX(Table[Segment]) = "B" &&

          MAX(Table[Code]) = "C", 900, [exicts])

i dont see this picture. The -900 will be only displayed when i filter Typ = A, Segment = B and Code = C. But when nothing is filtered the -900 should be shown also.

Hope i could explain it better. I do something like a data addition with a measure and maybe thats the problem.

Or say in other words: I want to expand my data for Typ = A, Segment = B and Code = C with these -900 and the filters should respond as usual.

[v-binbinyu-msft]

Hi @Pikachu-Power ,

In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

Thanks for your efforts & time in advance.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pikachu-Power]

I started some attempts yesterday but seems not as easy as i thought?