Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a situation where I need to calculate data and save it in different table for reporting
Raw data
I want result in below format
Solved! Go to Solution.
@PBX_user , Create a new table using DAX go to modelling and create new table and use Summarize
SecondTable =
SUMMARIZE(
'FirstTable',
'FirstTable'[Month],
'FirstTable'[State],
"No of Tasks", COUNTROWS('FirstTable')
)
Proud to be a Super User! |
|
@PBX_user , Create a new table using DAX go to modelling and create new table and use Summarize
SecondTable =
SUMMARIZE(
'FirstTable',
'FirstTable'[Month],
'FirstTable'[State],
"No of Tasks", COUNTROWS('FirstTable')
)
Proud to be a Super User! |
|
Thank you bhanu_gautam that worked.
I have different set of data as well, how I can create a result set of this data set
raw data:
Result needed as below:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 28 | |
| 19 | |
| 11 | |
| 10 |