cancel
Showing results for
Did you mean:
Member

DAX expression - ignore dimension from graph

Hi,

i don't know how to obtain a graph like this:

Label          Result

B                count all Label=A && Value=1 in this case result is 1

C                count all Label=A && Value=1 in this case result is 1

D                count all Label=A && Value=1 in this case result is 1

the graph is filtered with B,C,D /// A is excluded

the slicer of year, month etc need to be functionally

please take the base from below:

 ID Year Month Client Label Value 1 2018 1 cosmin A 1 1 2018 1 cosmin B 1 1 2018 1 cosmin C 1 1 2018 1 cosmin D 0 2 2018 2 cosmin A 0 2 2018 2 cosmin B 1 2 2018 2 cosmin C 1 2 2018 2 cosmin D 0 3 2018 1 ana A 0 3 2018 1 ana B 0 3 2018 1 ana C 0 3 2018 1 ana D 1 4 2018 3 ana A 0 4 2018 3 ana B 1 4 2018 3 ana C 1 4 2018 3 ana D 1

thanks,

Cosmin

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team

Re: DAX expression - ignore dimension from graph

Hi cosmic,

I am not clear about your requirement , did you mean that you won't want to show "A" in axis, and count label="A" and value =1  for B,C,D, right?

If so, you could try to use below measure to see whether it work or not(table 2 is for slicer which have only column have values A,B,C,D)

```Measure =
VAR s =
SELECTEDVALUE ( Table2[Column1] )
RETURN
IF (
s IN VALUES ( graph[Label] ),
BLANK (),
CALCULATE (
COUNT ( graph[Label] ),
FILTER ( ALL ( graph ), graph[Label] = "A" && graph[Value] = 1 )
)
)```

You need to set filter on measure to "is not blank"

If this is not what you want, please inform me your expecting output  by image or drawings

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 REPLIES 2
Community Support Team

Re: DAX expression - ignore dimension from graph

Hi cosmic,

I am not clear about your requirement , did you mean that you won't want to show "A" in axis, and count label="A" and value =1  for B,C,D, right?

If so, you could try to use below measure to see whether it work or not(table 2 is for slicer which have only column have values A,B,C,D)

```Measure =
VAR s =
SELECTEDVALUE ( Table2[Column1] )
RETURN
IF (
s IN VALUES ( graph[Label] ),
BLANK (),
CALCULATE (
COUNT ( graph[Label] ),
FILTER ( ALL ( graph ), graph[Label] = "A" && graph[Value] = 1 )
)
)```

You need to set filter on measure to "is not blank"

If this is not what you want, please inform me your expecting output  by image or drawings

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Member

Re: DAX expression - ignore dimension from graph

Thanks a lot!

Cosmin

Announcements

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Get your latest community news and announcements.

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 54 members 1,470 guests
Recent signins: