Blank rows in calculation groups

[ahmedshalabyy12]

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 

[mark_endicott]

@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!

[ahmedshalabyy12]

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 

[mark_endicott · Accepted solution]

@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]

This Worked Thank you