March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Solved! Go to Solution.
Hey Everyone,
Just tossing this bit of DAX language in here to show that the text can change based on the drill down in a chart. Just took a bit of trial and error on my part. See example below:
if(hasonevalue(name),
values(name) & " text text text " & [measure] & " above plan " & etc.... ,
if(hasonevalue(name)&&hasonevalue(state),
values(name) & " text text text " & [measure] & " above plan by" & [state],
etc...
The first IF statement will produce the text only if a 'name' is chosen. The 2nd IF statement will produce text if both a 'name' and a 'state' is chose....so drilling down on a name in a chart to get to the level with a state..then selecting a state will produce the statement.
Hey Everyone,
Just tossing this bit of DAX language in here to show that the text can change based on the drill down in a chart. Just took a bit of trial and error on my part. See example below:
if(hasonevalue(name),
values(name) & " text text text " & [measure] & " above plan " & etc.... ,
if(hasonevalue(name)&&hasonevalue(state),
values(name) & " text text text " & [measure] & " above plan by" & [state],
etc...
The first IF statement will produce the text only if a 'name' is chosen. The 2nd IF statement will produce text if both a 'name' and a 'state' is chose....so drilling down on a name in a chart to get to the level with a state..then selecting a state will produce the statement.
Its going to depend on your slicer and what you can draw from it. You could make use of FIRSTNONBLANK to get the text value of Johns name and then append it to the text you want.
No, the Dax language won't accept it as even though you know you've constrained the circumstances it still needs to treat it as a list of information. Using "FirstNonBlank" gets around this and stops on the first value it finds thats that not blank. Its going to have the performance saving you are expecting when you say you don't want a lookup.
K...so now I can't get a summarize columns expression to work. Any suggestions?
Summarize Test = SUMMARIZECOLUMNS(Dispatch[MANAGER_NAME],Dispatch[MARKET],"Market",SUM(Dispatch[Dispatch Count]))
I'm basically trying to get a dispatch count grouped by Manager & Market.
This is the full DAX code I'm using to find the max disp count by manager/market
MAXX(SUMMARIZECOLUMNS(Dispatch[MARKET],Dispatch[MANAGER_NAME],"Test",Dispatch[Disp Count]),[Test])
any help is greatly appreciated!
Hi @codyraptor,
Could you post your table structures with some sample data and your expected result? So that we can better assist on the measures.
Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
132 | |
90 | |
88 | |
64 | |
58 |
User | Count |
---|---|
203 | |
141 | |
107 | |
73 | |
70 |