Hey dude... Small addin U can use isfiltered function in if clause for city as below If (isfiltered (city), concatenatex (statement), "All")
@TrassBI2 жыл бұрын
Very useful video. Thanks for sharing👍
@rowanschoultz10222 жыл бұрын
Good tip!
@lawrencepalmer65422 жыл бұрын
Great DAX using variables for this! A lot cleaner and simpler doing it this way. BTW, how do you get the the KPI to have the description above instead of below. Are you just using a textbox for those?
@datapears2 жыл бұрын
You can add a title to your KPI card or a text box yes!
@lawrencepalmer65422 жыл бұрын
@@datapears Perfect! Didn't realized titles can be added to cards. Thank You!
@luisfernandomacedo1451 Жыл бұрын
Nice video! I used something similar at work, but I made condition for distinct count of filtered itens before concatenating.
@dylangao68502 жыл бұрын
You can use Filters(not Filter) function to show all the filtered cities.
@JohnOttoKnoke Жыл бұрын
How were you able to add background to filter area? Nice video too. Saludos