Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have the below matrix in the exact same format that I need.
Here, 'Labels' is a text field - both 'Labels' and 'Rate' I don't want to get summarized (as highlighted).
My fields pane -
This is a transactional date and there can be multiple occurances of the same product (hence the same Labels and rates) under each type - so using HASONEVALUE would not be of much help I think.
Please can someone help here?
Solved! Go to Solution.
Hi @RD2019
Create measures
Measure_column3 = IF ( ISINSCOPE ( 'Table'[column2] ), MAX ( 'Table'[column3] ), IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () ) ) Measure_column4 = IF ( ISINSCOPE ( 'Table'[column2] ), SUM ( 'Table'[column4] ), IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
Thanks for this...I think this would work as well. However I have applied a work-around using HASONEVALUE only. As in my case, every product has the same label code and rate - I have just use an IF condition stating that if there is one value for any label or rate (although there can be multiple occurances) - just take the AVERAGE value, otherwise BLANK (ensuring the subtotal will be blank). Seems that it's working fine now.
Did you tried to move “First Labels” and “Rate” from Values to Rows? You are getting total for text fields because you have placed these text fields in value section of matrix. see below screenshot
Hi @RD2019
Create measures
Measure_column3 = IF ( ISINSCOPE ( 'Table'[column2] ), MAX ( 'Table'[column3] ), IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () ) ) Measure_column4 = IF ( ISINSCOPE ( 'Table'[column2] ), SUM ( 'Table'[column4] ), IF ( ISINSCOPE ( 'Table'[column1] ), BLANK (), BLANK () ) )
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Maggie,
Thanks for this...I think this would work as well. However I have applied a work-around using HASONEVALUE only. As in my case, every product has the same label code and rate - I have just use an IF condition stating that if there is one value for any label or rate (although there can be multiple occurances) - just take the AVERAGE value, otherwise BLANK (ensuring the subtotal will be blank). Seems that it's working fine now.
I see repeating values, so assuming these are both columns, you can write measures as follows
=selectedvalue(table[column])
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |