topic Calculated measure not responding to my slicers in DAX Commands and Tips

Calculated measure not responding to my slicers

gghanem — Wed, 08 Mar 2023 16:36:08 GMT

Hello.

I have created a dashboard for my project that includes various demographic information (e.g. gender, nationality, vulnerabilities...etc.). Each case may contain multiple vulnerabilities.

I want my graph on Power BI to include the values for each individual vulnerability (similar to countif on excel). Most importantly, I didn't want the cells that contain multiple vulnerabilities to result in a new aggregated type of vulnerability.

Through a google search, I was able to find the following DAX formula which I repeated the same steps for all of the vulnerabilities:

Child/ Youth = CALCULATE(COUNT(Sheet1[Vulnerability,FILTER(ALL(Sheet1),[Vulnerability]="Child/ Youth"))

The measure worked perfectly and I was able to create a clear donut chart using the newly calculated measures.

However, my chart is not responding to my slicer.

How can I fix that?

Re: Calculated measure not responding to my slicers

tamerj1 — Wed, 08 Mar 2023 17:55:27 GMT

Hi gghanem
The ALL function removes all filters. As of you measures you can use

Child/ Youth = CALCULATE ( COUNT ( Sheet1[Vulnerability] ), Sheet1[Vulnerability] = "Child/ Youth" )

However there is no need to create a seperate measure for each Vulnerability rtaher you can place the [Vulnerability] column in the legend of the donut chart and place the following measure in the values

Count = COUNT ( Sheet1[Vulnerability] )

or even

Count = COUNTROWS ( Sheet1 )

and it should work

Re: Calculated measure not responding to my slicers

gghanem — Thu, 09 Mar 2023 07:55:07 GMT

Hello tamerj1

Thanks for the advice.

I tried this but it resulted in the aggregation that I was trying to avoid.

The problem here is that some cases have multiple vulnerabilities at once but I don't want to highlight the combination of vulnerabilities.

Rather, the graph that I want would only show the 6 primary categories as such:

This graph was created from the calculated measures using the formula I had shared in the first message.

Is there a way to accomplish this without severing the connection to the slicers?

Re: Calculated measure not responding to my slicers

tamerj1 — Thu, 09 Mar 2023 08:18:08 GMT

gghanem
Just create a new calculated column in the data table that categorize/group them into 6 groups.

Somthing like:
Category =
SWITCH (
TRUE ( ),
'Table'[Vulnerability] IN { "CHILD/YOUTH", "CHILD /YOUTH", "CHILD/ YOUTH", "CHILD / YOUTH" }, "CHILD/YOUTH",
etc..