How to use an IF statement measure in a BarChart?

[Anonymous]

I do not want to add calculated columns or tables to the model.

I have this DAX:

    IF(

        COUNTROWS(

            FILTER(

                table,

                table[column] = "xyz"

                && table[ID] = SELECTEDVALUE(dim_id[ID])

            )

        ) > 0,

        1,

        0

    )

This works when I put it in a table. But I also want to show the count in a bar chart grouped by other columns.

Thanks

[Anonymous · Accepted solution]

Thank you Ashish_Mathur and Shravan133

Hi, @Anonymous 

Based on your description, I've created the following sample data:

I use the following DAX expression to get the count:

Count = 
        COUNTROWS(
            FILTER(
                'Table',
                'Table'[column]="xyz"&&
                 'Table'[ID] IN VALUES(dim_id[ID])
            )
        ) 

Create a slicer using dim_id[ID]. Create a bar chart using the group and count Measure:

I've provided the PBIX file used this time below.

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

[Ashish_Mathur]

Hi,

Simplify the measure to

= calculate(COUNTROWS(table),table[column] = "xyz")

Hope this helps.

[Shravan133]

try this:

Measure_Count_XYZ =
CALCULATE(
COUNTROWS(
FILTER(
table,
table[column] = "xyz"
&& table[ID] = SELECTEDVALUE(dim_id[ID])
)
)
)

• Now, use Measure_Count_XYZ in the Values section of the bar chart.
• For the Axis, group by any columns you want, such as other dimensions or categories.

This will now dynamically calculate and display the count of rows where table[column] = "xyz" and table[ID] = SELECTEDVALUE(dim_id[ID]) in the context of the chart, grouping by whatever columns you place in the visual.