Dax for Region

[Anonymous]

Hello,

I am trying to execute below dax but not getting expected output.

I have region filter which has "NE, NW, S and Total. When i select "Total" then should show in my table visual

NE, NW,S and Total. Can someone please correct me.

SWITCH(V_PBI_DTA_SAM_Daily_Region[Region],"NE","NorthEast","NW","NorhtWest","S","South","Total","NE+NW+S",V_PBI_DTA_SAM_Daily_Region[Region])

Regards,

Venky

[Anonymous]

Hi @Anonymous,

I'd like to suggest you take a look at the following blog to achieve a dynamic attribute report: (you may need to create a table that stores different granularity of the records to map to the fact table records)

Dynamic Attributes In A Power BI Report - P3 Adaptive
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , You need create a table like this and join with region table or region field

NE , NE , NorthEast

NW,NW ,NorhtWest

S,S ,South

NE , Total, NorthEast

NW,Total,NorhtWest

S,Total ,South

[Anonymous]

These are all in one Column?

NE , NE , NorthEast

NW,NW ,NorhtWest

S,S ,South

NE , Total, NorthEast

NW,Total,NorhtWest

S,Total ,South

[ValtteriN]

Hi, 

Could you add a picture of what you are trying to achieve?

[Anonymous]

in my region filter i have the data like NE, NW, S and Total. When i select NE iam showing in my table Visual NorthEast and when i select NW from region filter showing in table visual as NorthWest and When i Select "Total" from filter should show in my table visual as NorthEast, NorthWest, South and Total. 

[Anonymous]