Calculation Group in Card (new) Visual - Display Dynamic Storage Units

[stefanjt]

Dear Community,

I need to show dynamic storage units based on a slicer selection (bytes, kilobytes, megabytes, gigabytes and terabytes) for "cold storage", "hot storage" and "total storage". I have created the 3 measures + the calculation group which dynamically converts the selected measure to the correct storage unit. I am displaying it correctly in a matrix visual, however I also need to make the units dynamically change in a Card (new) visual.

Here's my setup:

1. Database usage table:

2. Storage units table

3. Measures

Total cold storage = 
SUM(
    'Database usage'[Cold storage]
)


Total hot storage = 
SUM(
    'Database usage'[Hot Storage]
)


Total storage = 
[Total cold storage] + [Total hot storage]

4. Calculation group with this item:

Storage unit = 
VAR converted_storage =  
DIVIDE(
    SELECTEDMEASURE(),
    POWER(
        1024,
        SELECTEDVALUE(
            'Storage units'[ID],
            0
        )
    )
)

RETURN
FORMAT(
    converted_storage,
    "0,0.00 " &
    SELECTEDVALUE(
        'Storage units'[Storage unit]
    )
)

5. Visuals: 

I need help setting up the Card (new) visual so that it dynamically changes the storage units based on the selection from the slicer.

Any suggestions?

I am attaching a sample report: https://www.dropbox.com/scl/fi/49nnz5sqglay3v5iwgukp/Storage-Units-Demo-Calculation-Groups.pbix?rlke... 

Thank you in advance!

[tharunkumarRTK · Accepted solution]

@stefanjt 

You just need to add a visual level filter, Darg the calculation group column into the filters pane on the right and select the calculation item name: 

 for the new scorecard visual:

I am attaching the pbix file for your reference 

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[stefanjt]

@tharunkumarRTK,

Thank you so much, that worked!