Forum Discussion
Blank rows in calculation groups
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!
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 measure
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!
This Worked Thank you