creating rules or measures to display as KPIs in %

[sakamotothais]

Hi everyone,

I'm creating rules to display as KPIs and I'm having a question if anyone can help.

	Increased	Decreased	Neutral	Fare %
	33.33%	0.00%	0.00%	0.00%
	0.00%	50.00%	50.00%	52.59%
	50.00%	0.00%	0.00%	39.00%
	0.00%	100.00%	50.00%	46.00%
	0.00%	100.00%	100.00%	0.00%
Total %	11.11%	0.00%	0.00%	39.46%

Note that two columns do not calculate the percentage of the column total. Because?

How can I use a measure that depends on the filters you select, bring the proportion in KPI?

For example:

I have four pictures that I call KPI's.

1st frame - Percentage of which increased
2nd percentage figure than decreased
3rd percentage of everything that was neutral
4th percentage change rate

But because of the above table in power BI, I can not display when performing my filters by date,
Or market, the low and neutral frames are always zeroed.

Increased	Decreased	Neutral	Fare %
11.11%	0.00%	0.00%	39.46%

Anyone have an idea how to use it?

thanks

[v-ljerr-msft]

Hi @sakamotothais,

Could you post your table structures(including the measures you're using) with some sample/mock data, and the corresponding result? So that we can further assist on your issue. 

Regards

[sakamotothais]

Hello 

Here's an example to explain it better.

I have in the table the measures that show increase, neutral and decrease.

The calculation of the measurements follows.

Decreased = IF([Count D-1] > [Count D0], 1,0)/[Count D0]

Increased = IF([Count D-1] < [Count D0], 1,0)/[Count D0]

Neutral = IF([Count D-1] = [Count D0], 1,0)/[Count D0]

I'm comparing a value yesterday to value today according to my filter on capture date.

I will explain what I want correctly. Example I have 3 values ​​in item 1678. Yesterday I had 2 and had an increase today for 3. The increase in the graph represents 3 of 100%, which gives 33.33%

In my KPI's picture appears 33.33%

But when I want to do without filtering on the item, bringing all the items, my KPI's frames do not bring the percentage value of increase, neutral or decrease of the total.

Either it gets 0.00% or infinity. I want to adjust the percentage in my frames, neutral, increase and decrease.

Thanks

[sakamotothais]

Help?