Power BI DAX addition of new column dynamically or based upon condition

[Varshini1234567]

Hi 

I am struck in power BI  with one query in my development .

1) I have a dataset named raw data of the below format. I have created a matrix with SetArea -> ProjectGrouped->ProjectName as my hierachy row. 

2) I have a measure named plan which calculates full year sum of value based upon the selected slicer scenario for the present year. Please find the below measure ( Measures[scenario]) is an table which contains unique scenario data 

Plan= var LV = SELECTEDVALUE(measures[Scenario])

 return

 CALCULATE(

    sum(table[Sum of Value]),

    table[Scenario]=LV,

    table[Date (Year)]=FORMAT(YEAR(TODAY()),""))

Now I have a requirement, User have asked if project B or projectgrouped is <=10 then we need to get those data into "Others" in the matrix. And the Others should only be available if budget,MTP or RBU2 are selected. Others should not come for Actuals. 

For now I have tried creating a calculated column named value_grouped =

    CALCULATE(

        SUM(table[Sum of Value]),

        ALLEXCEPT(table, table[SET Area],table[Projects Grouped],table[Scenario],table[Date (Year)]),Raw_Data[Spend/Authorisation]="Spend"

    )

Based upon this calculated column I have created other set area column 

IF(Raw_Data[Value_Grouped]<=10|| Raw_Data[Value_Grouped] =0||Raw_Data[Value_Grouped]=BLANK(),"Others",table [SET Area])

but im not getting the actual result is there any  other way to achieve?

[Anonymous]

Hi @Varshini1234567 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @Varshini1234567 
I wanted to check if you had the opportunity to review the information provided by @amitchandak . Please feel free to contact us if you have any further questions. If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous]

Hi @Varshini1234567 

Thank you for reaching out microsoft fabric community forum.

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[amitchandak · Accepted solution]

@Varshini1234567 , Other needs to value in your dimension, then you can do that. I have done the same using an additional table, but you can do that with a single table

refer examples

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU
Power BI How to get two columns format Profit and Loss Statement(P&L) right: https://youtu.be/WLg85yiMgHI
https://medium.com/microsoft-power-bi/power-bi-formatted-p-l-with-custom-sub-totals-and-blank-rows-e...