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 · Accepted solution]

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

[v-bmanikante]

Hi @Hitha ,

As we haven’t heard back from you, 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.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Hitha 

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Please don't forget to give a "Kudos " – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy