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.
I'm looking for a way to incorporate a measure to do the following. I've got two slicers on my page one for Dealer Group and another for Dealer Number. Above my data I have a title that I'd like to be dynamic based on their slicer selected.
For example, if the user selected "Dealer Group A" in the slicer, the title would be "Dealer Group A"; however, if the user selected "99999" in the dealer slicer, the title would now read as "99999". These two fields are connected in a way, however, they are two seperate columns in the data set. Delaer Number is a sub category of Dealer Group, there can be multiple Dealer Numbers in a Dealer Group. I've got two measures that will pull the selcted value, but now I just can't figure out a measure to say: when one is selected, pull X, if another is selected, pull Y.
Dealer Group DAX Measure:
is that value always 99999 or any other. if it is same always, youcan use that logic
if(selectedvalue(column) = 999999,selectedvalue(column), selectedvalue(othercolumn) )
Proud to be a Super User!
No not in this case, there's thounds of values in both the Dealer Group and Dealer Name columns.