Forum Discussion
IF SUM dax issue
Hi Anonymous ,
I think you already have your own answer.
You can create the matrix like above from what you already have.
Best regards,
Hi Anonymous
That formula is table function so please click "New Table" as shown in the yellow highlighted circle below:
Best regards,
It is working fine (picture below), but I have one last concern 😊.
Isn't there any way of "grouping" the data inside my initial table? Because I have many other related necessary data inside there that I need to link & use to create filters/legends. The SUMMARIZE table you've just shown me is being created separately from my data.
Hi Anonymous
Does the below output meet your requirement? I've shown the total by fruit in a separate calculated column for an easier visualization of the steps taken, instead of doing all in one step which is more abstruct. I then wrote a simple if formula to separate out "<=15" and the "rest".
I attach an example pbix file.
Best regards,
This one does not help me 😢. Your previous solution in post #7 was the right one. But I would just need to replicate it directly inside the original datasource with all my data. Not as a separate table function. Is this possible?
What I am trying to achieve in the end is something like below. However, I need the "Grouping" to be a calculated column that performs the same result, but directly inside my datasource.
Basically I need your calculation to happen in my datasource: