Forum Discussion

rpablo's avatar
rpablo
New Member
3 years ago
Solved

Card value based on a table visual

Hi,   I'm building a report with multiple tables, and I would like to present a specific number of applications for the selected time period in a Card.   In my schema I have my main table as "Ses...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi rpablo ,

    If your model set as below screenshot, then create a measure as below to get the distinct count of App Name to replace the original value field in Card visual. 

    Distinct App Name Count = 
VAR _wkapp =
    CALCULATETABLE (
        VALUES ( 'Sessions'[WorkspaceAPP] ),
        ALLSELECTED ( 'Sessions' )
    )
VAR _appconfig =
    CALCULATETABLE (
        VALUES ( 'WorkspaceAPP'[AppConfig] ),
        FILTER ( 'WorkspaceAPP', 'WorkspaceAPP'[ID] IN _wkapp )
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'AppConfig'[App Name] ),
        FILTER ( 'AppConfig', 'AppConfig'[ID] IN _appconfig )
    )

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi rpablo ,

If your model set as below screenshot, then create a measure as below to get the distinct count of App Name to replace the original value field in Card visual. 

Distinct App Name Count = 
VAR _wkapp =
    CALCULATETABLE (
        VALUES ( 'Sessions'[WorkspaceAPP] ),
        ALLSELECTED ( 'Sessions' )
    )
VAR _appconfig =
    CALCULATETABLE (
        VALUES ( 'WorkspaceAPP'[AppConfig] ),
        FILTER ( 'WorkspaceAPP', 'WorkspaceAPP'[ID] IN _wkapp )
    )
RETURN
    CALCULATE (
        DISTINCTCOUNT ( 'AppConfig'[App Name] ),
        FILTER ( 'AppConfig', 'AppConfig'[ID] IN _appconfig )
    )

Best Regards

  • rpablo's avatar
    rpablo
    New Member
    3 years ago

    Thank you Anonymous 

    That worked as I expected.