topic Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures. in DAX Commands and Tips

How to convert a measure into a column and then use it as an attribute to re-calculate measures.

juanesteban14 — Fri, 07 Mar 2025 22:35:36 GMT

Hi to all, I'would appreciate if someone could help me to solve this:
I have a sales report that include SKU / Customer / Sales Quantity / Margin% and I need to classify in four cathegories my SKUs, to do that I create a Parameter for each measure to define the target number for each measure, Quantity and Margin. Based on those targets and real numbers, I've create a new column calculated, to categorize this two measeure in one, I mean, cathegory A, B, C and D, where, Cat A is when Quantity and Margin are higher than Targets parameters, Cat B is when Quantity is higher than Quanty Target and margin is lower than margin target. Cat C is when Quantity is lower than Quanty Target and margin is higher than margin target and Cat D is when Quantity and Margin are lower than Targets parameters.

The issue that I have is when I try to use this new column as an attribute, because based on that cathegory (A, B, C, D) I want to recaclulate quantities, margins and numbers of SKUs for each category A, B,C and D. Something like this:

Thanks,

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

lbendlin — Fri, 07 Mar 2025 23:02:18 GMT

Calculated columns are immutable. You cannot base them on measures.

Power BI does not support dynamic binning. You need to bring your own buckets.

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

Anonymous — Mon, 10 Mar 2025 07:26:59 GMT

Hi juanesteban14 ,

According to your description, categories are reached by measure. You can create a table with all the categories, use this column in the visualization and calculate data such as the total quantity of each category in the fact table by the measure.

Here is my test for your reference.

Custom Table.

Table 2 = DATATABLE("Category",STRING,{{"A"},{"B"},{"C"}})

Measure.

quantity = SUMX(FILTER('Table',[Categories]=MAX('Table 2'[Category])),'Table'[Value])

——————————————————————————————————————————————————

If my answer helps you solve the problem, please accept my answer as a solution and let it be seen by more people in need.

Best regards,

Mengmeng Li

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

v-ssriganesh — Mon, 21 Apr 2025 09:15:37 GMT

Hi juanesteban14,

Thank you for posting your query in the Microsoft Fabric Community Forum.

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

Thank you.

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

juanesteban14 — Mon, 21 Apr 2025 14:02:26 GMT

Thanks for your comments.

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

v-ssriganesh — Thu, 24 Apr 2025 04:32:13 GMT

Hi juanesteban14,

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

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

juanesteban14 — Thu, 24 Apr 2025 12:43:20 GMT

Thanks for taking the time to answer and send me this option. I've tried to implemented but I couldn't, I don´t know if I'm doing wrong but calculations are not right. I'll try to do it again from scratch. Thanks.

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

lbendlin — Thu, 24 Apr 2025 13:46:41 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: How to convert a measure into a column and then use it as an attribute to re-calculate measures.

v-ssriganesh — Mon, 28 Apr 2025 09:13:22 GMT

Hi juanesteban14,
Could you please confirm if this issue has been resolved? If it has, kindly mark it as the solution and share the details in the community to help other members.
Thank you.