Need a Dax to make a measure for counting the rows on a dynamic table using 2 parameters [Power BI]

[Hitha]

The Row count needs to be displayed on a Key card next to the table visual.

The Data of the Table is from two Parameters (Multi-selection) :
'Selected Dimensions P3'[Select Dimensions]
'Selected Measures P3'[Select Measures]
Rows on the Table keeps changing according to the field selection by the viewer. The row count on the key card should simultaneously change to the current number of rows displayed on Table Visual.

[v-bmanikante]

Hi @Hitha ,

Thank you for reaching out to Microsoft Fabric Community Forum.

As per our understanding of your scenario, here's the DAX measure that you can use to dynamically count the rows shown in a table visual based on the viewer's selection through field parameters:

DynamicTableRC =
VAR DimFields =
    ADDCOLUMNS(
        'Selected Dimensions P3',
        "IsVisible", ISINSCOPE([Select Dimensions])
    )

VAR VisibleDims =
    FILTER(DimFields, [IsVisible])

RETURN
    COUNTROWS(
        SUMMARIZE(
            'FactTable',          // Replace with your actual base data table
            VisibleDims
        )
    )

If this doesn't meet your scenario, we kindly request you to, share a sample dataset that mimics your use case (without sensitive information) along with the expected output, or upload a sample PBIX file so we can review the structure and assist with a more accurate solution.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Hitha ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy