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
Hi guys
I have two datasets feeding a rotaining tile by MAQ.
Dataset 1 = list of case closures
Dateset 2 = target closures by day
I've created a realtionship between the 2 datasets based on date.
In the measure section of the roattaing tile I use "LOT" from dataset 1 and perform a count
From dataset 2 I use targetclosures and perform a SUM.
Problem
I want to calculate within the tile CountofLOT/Sumtargetclosures, is this possible?
Hello @carlm1975
To investigate the problem, we need -
Please include the above items here or we can be reached at support@maqsoftware.com
Having a little more information about the situation will help us evaluate and address the issue faster.
Thanks!!
Hi @carlm1975,
Please share some sample data/pbix file and expected result. If will be help for clarify your scenario and testing.
Regards,
Xiaoxin Sheng
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 |
|---|---|
| 66 | |
| 45 | |
| 42 | |
| 28 | |
| 18 |
| User | Count |
|---|---|
| 200 | |
| 125 | |
| 102 | |
| 69 | |
| 53 |