Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I'm trying to get the percentages of the percentage of specific columns but Power Bi is getting the percentage across the row instead of a single colunm.
-------------------------------------------------------------------------------------------
AF % (DAX) =
Solved! Go to Solution.
@Gabe_07 , Try something like this
divide(SUM('BatchHeaders'[AF Column]) , calculate( [Total Weight], allselected('BatchHeaders')))
divide(SUM('BatchHeaders'[AZ Column]) , calculate( [Total Weight], allselected('BatchHeaders')))
@Gabe_07 , Try something like this
divide(SUM('BatchHeaders'[AF Column]) , calculate( [Total Weight], allselected('BatchHeaders')))
divide(SUM('BatchHeaders'[AZ Column]) , calculate( [Total Weight], allselected('BatchHeaders')))
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |