Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a way to control the CALCULATION in Matrix based on Drill Level?
In my DATA table, i have column "Quantity". When using the MATRIX Visual, the Column "Quantity" & "Hours" is Summed up.
But in my case, i do not want the column QUANTITY summed up at "House" Level. This is because the data in the table is based of different Types / Unit of Measures [Cubic Meters, Linear Meters, Each], and hence summing up the quantity at "House" Level does not make sense. For example, we can say it took 500 hours to install 1000 cubic meters of Concrete and 1000 hours to build the house.
Hence at the "House" Level, "Quantity" should be BLANK. Is this possible?
Solved! Go to Solution.
Hi @hackfifi,
Here is the calculated field formula i wrote for Quantity
=if(HASONEVALUE(Table3[Type]),SUM([Quantity]),BLANK())
Hope this helps.
Hi,
This should be doable, Please share the link from where i can download your Excel/PowerBI desktop file.
Thanks @Ashish_Mathur
Hopefully the below link works
https://1drv.ms/x/s!Ahwb9FOvNbslhRbnLJ_0Zz8Gubxs
Hi @hackfifi,
Have you tried the solution provided by @Ashish_Mathur above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?
If you still have any question on this issue, feel free to post here.
Regards
Hi @hackfifi,
Here is the calculated field formula i wrote for Quantity
=if(HASONEVALUE(Table3[Type]),SUM([Quantity]),BLANK())
Hope this helps.
Hi,
you can switch off the sub total option under format tab, but unfortunately you can’t control it by column wise.
Thanks @dilumd -Maybe i need to think of another visual to represent the data. Cheers
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |