Forum Discussion
Get Table visual row count when selecting fields using Fields Parameter
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-d0a041ac5581/download/ledger_fy22_qtr1.csv
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
3 Replies
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?
