Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi Team,
Could you please help me on below scenorio.
I have created the DAX function by using SWITCH function.please find the DAX column below.
When i use below calculation in Matrix, its summing up the values as State level and giving it in one column, but i need it in two columns, like Florida and Books combination value as one column and Florida and Chairs combination value as in different column.
Dataset
Formula
Measure1 = SWITCH(TRUE(), Table[State] = "Florida" && Table[Category] = "Books" , Table[Sales]),
Table[State] = "Florida" && Table[Category] = "Chairs" , Table[Sales])
When i use above formula it is giving result like below.
Florida | |
Measure1 | 300 |
But i require something like this.(Column names just for reference)
Florida+Books | Florida+Chairs | |
Measure1 | 100 | 200 |
Kindly help me with this requirement.
Solved! Go to Solution.
Hi @Anonymous
Not sure if I understand your requirement but I think you can create an extra column in your table that concatenates state and category and later use it as Matrix column.
New Column = table[state] & "-" & table[Category]
Hi @Anonymous
Not sure if I understand your requirement but I think you can create an extra column in your table that concatenates state and category and later use it as Matrix column.
New Column = table[state] & "-" & table[Category]
@Anonymous , both case you are returning sales , so no diff. Either you need two columns or Segmentation
https://www.daxpatterns.com/dynamic-segmentation/
https://www.daxpatterns.com/static-segmentation/
https://www.poweredsolutions.co/2020/01/11/dax-vs-power-query-static-segmentation-in-power-bi-dax-power-query/
User | Count |
---|---|
81 | |
75 | |
74 | |
42 | |
36 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |