Forum Discussion
Blank rows in calculation groups
Dears,
I have used calculation groups , but there are some blank rows i want to hide them but i cannot
filters applied (relative date last 2 years )
i used this fuction but not working
Selected Measure= if(isblank(selectedmeasure(),blank(),selectedmeasure())
power bi supposed to hide the blank rows but not working
so please assist me
Thank you
ahmedshalabyy12 - then you just need to adjust your calculation items for prev day, month and year to show BLANK() when isblank(Selectedmeasure()).
I'd imagine you can write that dax!
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
4 Replies
ahmedshalabyy12 - Setting something to BLANK() will not specifically hide rows, especially when you have data in Prev Day, Prev Month and Prev Year for most if not all of your dates.
You can set a visual filter for Selected Measure to say "is not blank" and this will hide the rows you do not wish to see.
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
i tried it but it's not working for the selectedmeasure
if you filter with basic you will find prev month prev year prev day and selected measure
so the filter not applied on the values inside selected measureahmedshalabyy12 - then you just need to adjust your calculation items for prev day, month and year to show BLANK() when isblank(Selectedmeasure()).
I'd imagine you can write that dax!
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
