Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
PBI-Curious
Resolver I
Resolver I

Label for Multiple Dax Measures

Hello PBI Community Good Day!

 

Looking for a Dynamic Dax Measure I can use with cards for multiple measures.

In the screen shot below I have 8.

In a perfect world I would like to have only 4 that will change with my calculation slicer. 

What I'm trying to accomplish:

Currently I have:

4 cards for Trailing Twelve Months  (TTM CY, TTM PY (GL) ect...)

and 

4 cards for Year to Date ( YTD CY, YTD PY (GL) ect...)

Look for a way to just use 4 cards that will change with my calculation slicer.

 

Please advise if you need additional information for clarity.

 

Regards,

 

klsmith_dnb_2-1628985432489.png

 

 

 

 

1 ACCEPTED SOLUTION
m3tr01d
Continued Contributor
Continued Contributor

You could use a disconnected table for that.

1) Make a table with two values Trailing twelve months and Year to date.
2) Make a slicer using this column
3) Build a dynamic measure that will change depending on the slicer selection

Dynamic_Measure_Card1 = 
--Grab the value from the slicer
VAR _SelectedValue = SELECTEDVALUE( 'DisconnectedTable'[Slicer], "Year to date")

--Change the calculation based on that value
RETURN
SWITCH(
	_SelectedValue,
	"Year to date", [YTD_Measure],
	"Trailing twelve months", [TTM_Measure]
)

 
The only problem with this approach is you'll have to create 4 dynamic measures (for the 4 cards)

A more elegant solution would include Calculation Group but this might be too much for what you are trying to accomplish.

View solution in original post

4 REPLIES 4
m3tr01d
Continued Contributor
Continued Contributor

You could use a disconnected table for that.

1) Make a table with two values Trailing twelve months and Year to date.
2) Make a slicer using this column
3) Build a dynamic measure that will change depending on the slicer selection

Dynamic_Measure_Card1 = 
--Grab the value from the slicer
VAR _SelectedValue = SELECTEDVALUE( 'DisconnectedTable'[Slicer], "Year to date")

--Change the calculation based on that value
RETURN
SWITCH(
	_SelectedValue,
	"Year to date", [YTD_Measure],
	"Trailing twelve months", [TTM_Measure]
)

 
The only problem with this approach is you'll have to create 4 dynamic measures (for the 4 cards)

A more elegant solution would include Calculation Group but this might be too much for what you are trying to accomplish.

M3trO1d... GM

 

We appear to be on the same page. Will give your suggestion a try.

Thank you for your quick response!

Regards,

Greg_Deckler
Super User
Super User

@PBI-Curious I am not entirely certain of what you are trying to do exactly but take a look at this dynamic title measure: The Most Amazing, Mind Blowing Dynamic Slicer Titl... - Microsoft Power BI Community


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Hello Greg GM - much appreciate your quick response.

Looking for a dynamic dax measure that will update the 4 cards based on what I select per my calculation slicer MTD, QTD, YTD and TTM.

The 4 cards in my screen shot are currently showing my calculation slicer selection TTM.

Does this addition information help to deteemine what I'm trying to accomplish?

Will take a look at your link provided.

 

Thank you!

klsmith_dnb_0-1629118209172.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors