The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello!
I am sorry if the subject is not clear enough, I will try to explain it with pictures.
I have a grid with some "single entries" like this one
When I collapse the entry, I would like to see only the "Requirement summary" field filled, while the "Issue Summary" and the "Story points" ones stay blank, but I end up with this:
Any ideas?
Many thanks in advance!
Solved! Go to Solution.
Hi @DanCerf
If you want all subtotal blank, you can create these two measures and then create the visual with them.
Collapse Issue Summary = IF(HASONEFILTER('Table'[tables code]),MAX('Table'[Issue Summary]),BLANK())
Collapse Story points = IF(HASONEFILTER('Table'[tables code]),MAX('Table'[Story points]),BLANK())
The result looks like this:
If you want grid with multiple entries show the subtotal and grid with single entry stay blank, try these Measures.
Collapse Issue Summary =
VAR num =
CALCULATE (
COUNT ( 'Table'[tables code] ),
ALLEXCEPT ( 'Table', 'Table'[Requirement] )
)
RETURN
IF (
HASONEFILTER ( 'Table'[tables code] )
|| num >1,
MAX ( 'Table'[Issue Summary] ),
BLANK ()
)
Collapse Story points =
VAR num =
CALCULATE (
COUNT ( 'Table'[tables code] ),
ALLEXCEPT ( 'Table', 'Table'[Requirement] )
)
RETURN
IF (
HASONEFILTER ( 'Table'[tables code] )
|| num > 1,
SUM ( 'Table'[Story points] ),
BLANK ()
)
The result looks like this:
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @DanCerf
If you want all subtotal blank, you can create these two measures and then create the visual with them.
Collapse Issue Summary = IF(HASONEFILTER('Table'[tables code]),MAX('Table'[Issue Summary]),BLANK())
Collapse Story points = IF(HASONEFILTER('Table'[tables code]),MAX('Table'[Story points]),BLANK())
The result looks like this:
If you want grid with multiple entries show the subtotal and grid with single entry stay blank, try these Measures.
Collapse Issue Summary =
VAR num =
CALCULATE (
COUNT ( 'Table'[tables code] ),
ALLEXCEPT ( 'Table', 'Table'[Requirement] )
)
RETURN
IF (
HASONEFILTER ( 'Table'[tables code] )
|| num >1,
MAX ( 'Table'[Issue Summary] ),
BLANK ()
)
Collapse Story points =
VAR num =
CALCULATE (
COUNT ( 'Table'[tables code] ),
ALLEXCEPT ( 'Table', 'Table'[Requirement] )
)
RETURN
IF (
HASONEFILTER ( 'Table'[tables code] )
|| num > 1,
SUM ( 'Table'[Story points] ),
BLANK ()
)
The result looks like this:
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, it works like a charm!
Hello 🙂
Any idea here?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
93 | |
83 | |
64 | |
58 |
User | Count |
---|---|
246 | |
124 | |
115 | |
79 | |
78 |