Get Table visual row count when selecting fields using Fields Parameter

[ppdas2112]

Hi Power BI experts, hope you are doing well!

I have a Table visual on my dashboard, the columns/fields for which are selected using a Fields Parameter slicer. So, the number of rows change dynamically based on the selection of Fields, of different granularity, in the Fields Parameter slicer.

How can I create dynamic row counts measure for this Table visual? Kindly help!! 

Please consider this dataset: https://data.ok.gov/dataset/dd1ecf41-4abc-4886-ab0f-b84d7662d8d4/resource/6fe771bd-a705-4fce-b12f-d0...

if we select just FISCAL_YEAR in Fields Parameter slicer, the Table visual will show just 1 row. But if we select both FISCAL_YEAR and ACCOUNTING_PERIOD in Fields Parameter, the number of rows will b 4 on the Table visual. How to capture this changing Row Count in a measure?

@amitchandak @Ritaf1983 @Ahmedx @lbendlin @Ashish_Mathur @Greg_Deckler @johnt75 @NaveenGandhi @ryan_mayu @MFelix @DOLEARY85 @Kishore_KVN @Idrissshatila @Syk @vicky_ @Jihwan_Kim @barritown @ddpl @ppm1 @danextian @nvprasad @parry2k 

[ppdas2112 · Accepted solution]

The problem has been solved, thanks to @lbendlin 

https://community.fabric.microsoft.com/t5/Desktop/Count-rows-in-table-visual-with-Field-Parameters/m...

[danextian]

Hi @ppdas2112 ,

As always, please post a sample  (that we can copy paste in Enter Data) data and your expected result.

[ppdas2112]

https://data.ok.gov/dataset/dd1ecf41-4abc-4886-ab0f-b84d7662d8d4/resource/6fe771bd-a705-4fce-b12f-d0... 

Hi @danextian  , I am using a Table visual. Take the above data as example. If we just select FISCAL_YEAR in the Fields Parameter slicer, the number of rows in the Table will be much lower compared to if we take both FISCAL_YEAR and ACCOUNTING_PERIOD. How do we capture that changing row count basis our selection in Fields Parameter slicer in a measure?