Forum Discussion
Row context Filter
Hi v-xiaotang
this was answered in another post
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dax-CALCULATION-ISSUE/m-p/2485927#M68256
Hi Anonymous
Create 'Specific Rows' Table or import it from it from excel. Then create a measure
Filter Measure =
COUNTROWS ( FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) )
Place this measure in the filter pane of the table visual and select "Is not blank" and apply the filter.
Anonymous
Some like this
IF (
ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),
"",
[measure]
)
however, you might recieve error
tamerj1 Thanks, i will try it. But, i tried something like below it won't display anything .
Anonymous
I'm a little lost here. Do you want to show the value for the other rows as blanks or you want to entirely hide the row?
Yes!. I want to show the value of the other row as blank. Everything will be mapped to GM % only which i already have. Some like this.
tamerj1 The Specific rows is part of the Line Description. Line Desc is the column name.
Yes. You should have them in a separate single column table. Of course you should use the real name of this column and its table.
tamerj1 Your DAX works, But, i want the % to display only on the listed row not on other rows. right now it still display on other rows.
Hi Anonymous
then use
IF (
ISEMPTY (FILTER ( Finance, Finance[Line Description] IN 'Specific Rows'[ Specific Rows]) ),
[measure],
""
)however, you might recieve error