cancel
Showing results for
Did you mean:

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

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.

Regards,

1 ACCEPTED SOLUTION
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.

4 REPLIES 4
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.

Resolver I

M3trO1d... GM

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

Thank you for your quick response!

Regards,

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

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Resolver I

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?

Thank you!

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors