The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
I would like to know certainly something easy and simple ...
The objective is to display in a card the data "Name of Brand" that is selected in the filter "Brand" otherwise, if no selection then diplay a blanck.
Is it possible to do a dax formula with " (Brand[Name of Brand] is not selected, "", [Brand of name])
Thank you in advance for your help,
Léna
Solved! Go to Solution.
I am back with a solution that works :
Mesure = if(ISFILTERED('Brand'[Name of brand]),FILTERS('Brand'[Name of brand]),"")
Maybe we can optimise it ?
hi @LD1
try to plot a measure like:
Measure =
IF(
SELECTEDVALUE(data[brand])=BLANK(),
"",
SELECTEDVALUE(data[brand])
)
I am back with a solution that works :
Mesure = if(ISFILTERED('Brand'[Name of brand]),FILTERS('Brand'[Name of brand]),"")
Maybe we can optimise it ?
User | Count |
---|---|
28 | |
11 | |
8 | |
6 | |
5 |
User | Count |
---|---|
35 | |
14 | |
12 | |
9 | |
7 |