Forum Discussion

stefanjt's avatar
stefanjt
Frequent Visitor
1 year ago
Solved

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

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?rlkey=18z9migyo8q13aady0bmk1b4u&st=qmdqg3rc&dl=0 

 

Thank you in advance!

  • 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!


     

2 Replies

  • 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!