Forum Discussion
Conditional display for total in matrix
I add a total for level2
How can I hide level2 when it's blank and I need to keep the total for level1?
| Auto | Total | 4 |
| Click & go | 2 | |
| Refeerence | 2 | |
| Moto | Total | 2 |
| Sante | Total | 2 |
https://drive.google.com/file/d/10s7o4Ojl4JAq7qIjIAY29hB99tRGLyIZ/view?usp=drivesdk
Hi Anonymous ,
Create a measure as a logical condition for [AN].
Measure 2 = VAR test1 = IF ( ISINSCOPE ( Dim_Produit[Dim6Rapport] ), TRUE () ) RETURN IF ( ISINSCOPE ( Dim_Produit[Dim5Rapport] ) && MAX ( Dim_Produit[Dim6Rapport] ) <> "null", TRUE (), NOT ( test1 ) )Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907Also, MM3TR&R: https://community.powerbi.com/t5/Quick-Measures-Gallery/Matrix-Measure-Total-Triple-Threat-Rock-amp-Roll/m-p/411443#M150
Anonymous , refer if this can help
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
Hi Anonymous ,
Create a measure as a logical condition for [AN].
Measure 2 = VAR test1 = IF ( ISINSCOPE ( Dim_Produit[Dim6Rapport] ), TRUE () ) RETURN IF ( ISINSCOPE ( Dim_Produit[Dim5Rapport] ) && MAX ( Dim_Produit[Dim6Rapport] ) <> "null", TRUE (), NOT ( test1 ) )Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
