Card visual does not filter by measure

[Avivek]

I have a table which shows the values based on a measure as a filter,

Is DeltaValue = IF([From Sales Amount]+[To Year Sales]+[YOY Sales Growth details %]=0,0,1)

Filter is  Is DeltaValue is 1.

Now I want to add card visuals on the page to show the same totals from the table but since the visual level filter can't be applied on the card visual there is a difference in the values.

 I tried to create a table with Sales amount and another column, added the filter Is DeltaValue is 1 on the table. Remove the additional column and change the visual to card. Despite doing the filter and filter being seen on the visual but the values seems to change once the additional column is removed.

Is there any other way of showing the card visual with the visual level filter.

[v-henryk-mstf · Accepted solution]

Hi @Avivek ,

Since the card only shows one value that is always aggregated, we cannot add filtering criteria based on this aggregated value. Even by changing the table visual to a card visual, the filter added to the card visual cannot be changed, and the corresponding value will change accordingly with the slicer.

change to card visual

When the specified field under the Visual level filters pane contains multiple values, we can set the filter conditions through advanced filtering.

If the problem is still not resolved, please provide the appropriate screenshot information to show your desired results so that I can understand your needs.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Avivek , This will work at grand total level, May be you need force row context using addcolumns and summarize

example.  column and column1 are group by of table visual

sumx(addcolumns( summarize(Table, Table[Column], Table[Column2), "_1", IF([From Sales Amount]+[To Year Sales]+[YOY Sales Growth details %]=0,0,[Sales amount]) ) ,[_1] )

[Avivek]

Thankyou @amitchandak , but I did not understand context of tables and columns in th eabove given measure. 

When I said table I meant table visual and by column i meant the column from a fact table.