Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
hi all
I have one problem which let me headache for days and wish to seek help your support.
My scenario is quite simple, to compare the sales of certain product on a yearly basis in the matrix visualization.
The table used called CarSales, and the contents as follows, the measure I created called Measure_GAP, coding as follow,
Thanks in advance for solving the problem for me!
Best Regards
Yurong ZHANG
Solved! Go to Solution.
Hi @yurongzhang,
Theses 'blank' cells should be due to your table records. If they not really include in your tables, the measure expressions will not calculate on not existent range and keep show blank results. (measure not able to work as category/axis fields to expand the calculations ranges, they can only calculate with current row context)
BTW, power bi also include an auto existed filter effect on visual to hide the field which not has correspond values. They has higher priority than your measure formulas calculation and will auto filter to hide these fields.
For this scenario, I'd like to suggest you check the row/column field which not has correspond records and create a new unconnected table with that field values to replace the raw field which matrix used.
After these steps, you can modify your formula to check current row and column value as condition and lookup and summary table records.
Regards,
Xiaoxin Sheng
Hi @yurongzhang,
Theses 'blank' cells should be due to your table records. If they not really include in your tables, the measure expressions will not calculate on not existent range and keep show blank results. (measure not able to work as category/axis fields to expand the calculations ranges, they can only calculate with current row context)
BTW, power bi also include an auto existed filter effect on visual to hide the field which not has correspond values. They has higher priority than your measure formulas calculation and will auto filter to hide these fields.
For this scenario, I'd like to suggest you check the row/column field which not has correspond records and create a new unconnected table with that field values to replace the raw field which matrix used.
After these steps, you can modify your formula to check current row and column value as condition and lookup and summary table records.
Regards,
Xiaoxin Sheng
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
2 |