Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I am trying to write a function that will switch columns based on a given slicer selection.
My slicer is a disconnected table that has only two variables in it: Allocated and Not Allocated.
The two columns I am switching between are as follows:
Consignee Parent: is from a database so it is just a list of parents
Allocated Consignee Parent: a column from Power Query in which I duplicated Consignee Parent and replaced "X Distribution" with BLANK().
Here is my switching function (a calculated column) in question:
The problem is that even though I am engaging the slicer, it remains on Consignee Parent the entire time.
What I'm wanting it to do is either remove or add X Distribution to the rows of my matrix.
Thank you and I look forward to your responses.
@ofoster , A calculated column can not use a slicer value.
You can have table with these two values and use the value to switch the measures
example
W/WO X = SWITCH(SELECTEDVALUE('Allocation'[Commerce Allocation]),"Allocated", count('Consignee Parent'[Allocated Consignee Parent]), Count('Consignee Parent'[Consignee Parent]))
I used this solution as a jumping board to make a usable solution. I created a measure in the same format, but instead of the columns, "Allocated Consignee Parent" and "Consignee Parent", I created two calculated columns "Alllocated Binary" and "Binary".
Their equations are as follows:
User | Count |
---|---|
82 | |
78 | |
62 | |
61 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |