Matrix Visual - Filter/Exclude/Hide empty/blank multi level column measure
Hi guys! I need your wisdom, please! 😊 There is a data model, which I represent in Matrix visualisation, it contains multiple-level rows and columns values, see Pic 1: Pic 1 - Matrix visualisation I defined some measures - A/B simple one, but I need to show it under [Version] = "ACT" only, so I put a condition contains "Filter" function into it, here u can see it on Pic 2: Pic 2 - "vs_BG%" measure definition Measures appear in every single [Version], but only "ACT" contains not blank values. Its almost there, but my ideal state is on Pic 3: Pic 3 - Ideal state I need to suppress empty items, because calculated measures have to be under "ACT" [Version] only, other [Versions] have to contain "Value" only. I used this definition in Excels Power Pivot and it works the way I want, but PBIs behaviour is different. Pic 4 - Excels DAX measure Test in Pivot Table Pic 5 - Measures definition in Power Pivot Could you please suggest me, how can I reach my ideal state? Thanks in advance! 😄
How to replace empty cells in matrix with another value?
Grettings, I'm trying to fill this empty cells on this table with the value "100%". I've already applied "ISBLANK" and "+0" at the end of the formula. Is there any other way to fill these cells? The values "%" showed are a calcutated column of two measures.Fill empty dates with value from enddate
Hi, I have projects which have a residual amount that needs to be used before the enddate. So i calculated the amount that has to be spend per month before the enddate. I made a matrix and the result is this: So in the mond of the enddate of an project u see the amount that's need te be used per month for the rest of the duration of the project. I would like to fill the empty months with the value of the enddate. In the model i have a relation between enddate and the datetable which is used in de columns of the matrix. Which DAX formula can help me fill up the empty columns?
