Forum Discussion

Avivek's avatar
Avivek
Icon for Post Partisan rankPost Partisan
4 years ago
Solved

Card visual does not filter by measure

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.
 
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    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.

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    4 years ago

    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's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Avivek
      Icon for Post Partisan rankPost Partisan
      4 years ago

      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.