Forum Discussion
How to do 3 layer group by
How to do the below in Powerbi: First you group by three columns ID, desc and qty. second, from the output above, you group by ID and Desc, lastly by ID. I have a table with the below columns: P...
Md_asgar , The code seem fine. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
You can do this using a measure in visual
DAX Measure =
Sumx(Summarize(Table, Table[ProdoNum], Table[ProdoDesc], Table[QuantityOH], "_1", countrows(Table)),[_1])
amitchandak sure, below is the sample data link :
