Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi There,
I am trying to build a calculaion to identify the total sum of values of product code. In tableau, we do use, {FIXED [PRODUCTCODE]: [SORT_SLICER_VALUE]}. But in power BI, I have wrote the same like below
output = CALCULATE([SORT_SLICER_VALUE],ALLEXCEPT('ProductMaster',' ProductMaster'[PRODUCTCODE]))
SORT_SLICER_VALUE = SWITCH(SELECTEDVALUE('Slicers Des'[Slicer Des]),
"Price variance/ kg Original - Actual", [Price variance/kg Original - Actual],
"Price variance/ ctn Original - Actual", [Price variance/ctn Original - Actual])
But this calculation returns the same disaggregated value in the [SORT_SLICER_VALUE] measure. As an example,
Solved! Go to Solution.
Hi @SriGaG1 ,
According to your description, I have created a simple sample:
It works fine in my side:
Measure = CALCULATE([SORT_SLICER_VALUE],ALLEXCEPT(ProductMaster,ProductMaster[PRODUCTCODE]))
If something is not quite the same as yours, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @SriGaG1 ,
According to your description, I have created a simple sample:
It works fine in my side:
Measure = CALCULATE([SORT_SLICER_VALUE],ALLEXCEPT(ProductMaster,ProductMaster[PRODUCTCODE]))
If something is not quite the same as yours, please provide me with more details about your table and your problem or share me with your pbix file after removing sensitive data.
Refer to:
How to provide sample data in the Power BI Forum
How to Get Your Question Answered Quickly
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@SriGaG1
SELECTEDVALUE('Slicers Des'[Slicer Des]) , this is what you have used to impact on allexcept but in the table it is not appearing, have you used it as a slicer externally!
Proud to be a Super User!
@VijayP Exactly. I have created an extrernal table. Based on that table the slicer is determined. So is there any work around to do this ?
If you could mention what the desired outcome , it helps to give a solution
Proud to be a Super User!
@VijayP thank you for the comment. Actually the required outcome is mentioned in the table i have provided. I will paste that one here as well. Pls refer the final column.
Thanks
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |