Tagging a value with a measure and greater/lower condition

[Anaxielia]

Hi,

I am working on a project that shows credit distribution over work areas. My raw data contains customer number, risk amount,branch and customers area of work information. I wrote a measure to see what is the risk distribution over sectors, as below:

RiskAmountbySector = 
SUM ( 'Risk'[ProfitlessRisk] )
    / CALCULATE ( SUM ( 'Risk'[ProfitlessRisk] ); ALL ( 'Risk'[SectorID] ) )

measure works like charm. However,  I want to show the sectors those percentage is 2% and below as "Other" in bar graphic whenever i change the branch. 

any help is appreciated.

any help?

[v-alq-msft · Accepted solution]

Hi, @Anaxielia 

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

Table:

You may create a calculated column as below.

New Category = 
IF(
    [Percentage]<=0.02,
    "Other",
    [Category]
)

Result:

Best Regards

Allan

If this post helps,then consider Accepting it as the solution to help other members find it faster.

[amitchandak]

@Anaxielia , I think should be similar to TOPN + others, See if this can help

https://www.youtube.com/watch?v=UAnylK9bm1I

[Anaxielia]

Hi ,

I have a problem with that tutorial:

- I followed the steps however, when i tried to put into a measure, i cant select the column that would work as "used or other" info. I got "A circular dependency" error if i create as a new column. because the measure i want to rank, is using the same column (sector ID) and calculates the percentage of the risk of sector.