Showing a kpi only in particular conditions

[Luca21]

Hi,

I have a table where I show some measures (that aggregates values from different tables). These measures are grouped by a Category.

I would like to show a kpi just for some of these categories.

In the following example I would like to show the kpi just for category "two" and "four".

Category	actual	placed	planned	kpi
one	100	120	150
one	200	240	190
two	100	120	150	OK
two	200	240	190	KO
two	100	120	150	OK
three	200	240	190
four	100	120	150	OK

How can i get this result?

Thanks for any suggestions

Luca

[amitchandak]

@Luca21 , You can use a slicer and filter the value of the category

Also, you can create measures like

placed new  = calculate([placed], filter(Table, Table[Category] in {"two", "four"}))

[Luca21]

Thanks for your prompt answer.

It is not exactly the soluton I was looking for, but you give me a suggestion to solve my problem in other way.

Thanks

L

[amitchandak]

@Luca21 , Good to know that your issue is resolved. Kudos to you. Please share the solution if possible

[Luca21 · Accepted solution]

I tried  the solution of amitchandak but I had the problem that the filter should be done on an aggregate value but I needed to use a row value.

So i created a new measure that aggregate for the same table some default values and based on this new measure I can use the DAX expression suggested by amitchandak .

L