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.
Product visual table
Headers | | ProdName | | Average | | MIN | | MAX |
Fields | | ProdNameCol | | Average_Of_mProd | | MIN_Of_mProd | | MAX_Of_mProd |
SubProduct visual table
Headers | | SubProdName | | Average | | MIN | | MAX |
Fields | | SubProdNameCol | | Average_Of_mSubProd | | MIN_Of_mSubProd | | MAX_Of_m_SubProd |
In visual Product table i using this measure
mProd =
Solved! Go to Solution.
Hi @Analitika ,
Maybe you can create a calculated column like this.
Sum__Prod =
IF(
[SumSubProd] <> BLANK(),
[SumSubProd],
[SumProd]
)
Then add this calculated column to the matrix and calculate average, maximum and minimum respectively.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Analitika ,
Can the [measureProd] measure return the correct value? Does it all return 0?
Please give a sample data and screenshots of your two visual tables.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
[measureProd] return correct info while meet criteria 'Table'[Code] = 'Table'[Code2];
I cant post visuals as it is confidencial info
Hi @Analitika ,
Has your problem been solved?
You have too little information to share, I cannot judge the error. Maybe you can refer to my .pbix file(Although I did not reproduce your problem.).
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
TY. Look please for updated question. attached PBIX
Hi @Analitika ,
As you can see, when you filter the [SubName] column, the [SumProd] column will return blank value. This is not a formula error, but your original data itself has such a correspondence.
In other words, it is correct to return a blank value.
Or you can assign the blank value to 0.
SumProd =
VAR x =
IF(
'Table'[Code1]='Table'[Code2],
DIVIDE('Table'[Price],'Table'[Count])
)
RETURN
IF(
x = BLANK(),
0,
x
)
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I know that. So how to do what i need? As i need to see ProductName and his averages when press on SubName
Hi @Analitika ,
Maybe you can create a calculated column like this.
Sum__Prod =
IF(
[SumSubProd] <> BLANK(),
[SumSubProd],
[SumProd]
)
Then add this calculated column to the matrix and calculate average, maximum and minimum respectively.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |