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.
Hi guys!,
I have a measure I created where if it equals to this chain it will return zero, I got the correct output but when I tried putting a total column values does not show only returns zero, how to return the total for each column even with zero in another column
Hi yes here is the file
you can download here
https://drive.google.com/open?id=1epfvyS6oSIkCpAH0li01cy4dhmDv_fTM
also I just wanna add the reason why I want it to be zero is to be able to manipulate the field containing the Chains (Bellings, Ready Wear) I want to see that even if ready wear has sales I want it to be valued as a null column which will hide the column itself and the total and grand total to show the remaining total of the columns. but I still need the process of zeroing values so that if ever I choose to add more items to CHAIN field I would be able to choose who I want to zero out and who should be added to the total columns
here is a screenshot of my to be output
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 |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |