Forum Discussion
Parameter in summarize
Hi Anonymous ,
Thank you for reaching out to us on Microsoft Fabric Community Forum. Also thanks Nasif_Azam and rajendraongole1 for the helpful insights!
I tried to recreate it on my local upon my understanding.Please refer the screenshot and file for your reference.
If this answer meets your requirement,give us kudos and consider accepting it as solution.If still require further assistance, feel free to reachout!
Regards,
Pallavi G.
Hi Anonymous ,
Yes ,grouping by EntryIdentifier happens within your measure when we use CALCULATE(SUM(...), ALLEXCEPT()). And for your follow-up, you are right that with this filter solution, you are limited to filtering by the sum per entry and then retaining those IDs in your visuals. If you want to group by another column and sum a different field after that, you would need to create a new table or a new measure to account for that.
Hope this helps.
Thank you.
Anonymous Yes I tried to do this within a same table to achieve below but I couldn't do it. I think creating different table may not solve the purpost right? 1st group by based on the parameter and on top of the 2nd group by. Not sure how to achieve this..
Basically below is the output which I am expecting... We have already done the 1st of part.. but doing the 2nd part on top of the 1st part I am not getting how to do it...
SELECT
HsCode,
SUM(SupplementaryUnitQty) AS TotalSupplementaryUnitQty
FROM
[dbo].[CBAM_Goods_InScope]
WHERE
[EntryIdentifier] IN (
SELECT [EntryIdentifier]
FROM [dbo].[CBAM_Goods_InScope]
GROUP BY [EntryIdentifier]
HAVING SUM([CustomsValue]) > 500
)
Hi Anonymous ,
I'm glad the original question around dynamic filtering using the threshold slicer is resolved!
You are now moving into a more advanced scenario involving grouped summaries with conditional filtering which is a different use case.
To help keep this thread focused and useful for others with similar issues, I kindly suggest creating a new post for this next requirement. We will be happy to assist you further!
Thank you for your understanding!Anonymous I have closed this thread as you have mentioned. I have created the new thread for the next part of requirement as you have mentioned. So can you please help me out for the same?
Grouped summaries with conditional filtering - Microsoft Fabric Community
Anonymous Can you please help me out here with some solution or alternate other than DirectQuery since we would want to achieve this using import mode for its flexibility.