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
Is it possible to do a specific callcualtion for a row/colum total
Per below i need the total NBCP value to being the Total RFS/Total NWB = 435 and not the sum of that column??
Help will be highly appreciated
Solved! Go to Solution.
Hey!
That would be something like this:
CALCULATE(
SUM( YourColumnToSum),
ColumnwithText = "YourWord"
)
Let me know if that helps!
Hi Pablo
Need some help on a formula...
What formula would i use if i wanted to total a column value if it includes a specific word in anothe column?
If there is a word in column X c that is CONT sum the total colum for only those rows that have that word in the colum X?
Hey!
That would be something like this:
CALCULATE(
SUM( YourColumnToSum),
ColumnwithText = "YourWord"
)
Let me know if that helps!
Hi there!
You can try:
Measure =
IF(
HASONEVALUE( YourCategory ),
CurrentCalculation,
Total RFS/Total NWB
)
Let me know if that helps!
Hi
Sorry a little confused with the below..what would I add to category…and I cant seem to add in a formula at te end..do i need to do a measure for the total RFS and total NWB
Measure = IF( HASONEVALUE( YourCategory ), [NBCP per RFS] , Total RFS/Total NWB )
Hi!
CAB would be you "Category", I assume CAB stands for "Cabinet" which you already added, so it looks good.
For Total RFS/Total NWB you need to either create a measure that returns the value you want in the total, or apply the calulation right there.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
42 | |
33 | |
30 | |
18 | |
18 |