Forum Discussion
Make a Card Visual Start as blank
- 6 years ago
Anonymous , Try isfiltered
if(isfiltered(Table[zip code]),max(Table[Zip Code]),blank())
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Hi Anonymous ,
First thing it will be nice if you can tag the person you are replying to in your response.
Your last response is not clear to me regarding the text fields.
Please explain your query in detail rather than us guessing.
Thanks,
Pragati
Pragati11 My query pulls in all of our sales area data. The purpose of the report pictured above is when a new customer is showing interest into our business a sales manager could type in the zip code to get all the necessary data shown to them instantly. I obviously do not what there to be data showing instantly so I want all the tiles to be blank. The formuals sent thus far would work for showing a card blank for zip codes but I am not sure how to transalte that to text fields as the formula did not work when replacing it with other columns.
- Pragati116 years ago
Super User
Hi Anonymous ,
Can you share some sample data or how you are trying to write the measure for other text fields? I still don't understand the problem complete.
Thanks,
Pragati
- Anonymous6 years agoNot applicable