The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi everyone,
Im strugleling with on of my measure in matrix viz, see the following measure :
I said right blank if the calculation is negativ or just do the calculation, but the grand total in matrix still the same, see the matrix result :
How can I force the right grand total ?
Thanks in advance for your advices.
BR
Julien
Solved! Go to Solution.
Hi,
Please check the below measure whether it suits your requirement.
V3 measure: =
SUMX ( DISTINCT ( calendartable[Mois] ), [total_days_billable_retreated_V2] )
Hi,
Please check the below measure whether it suits your requirement.
V3 measure: =
SUMX ( DISTINCT ( calendartable[Mois] ), [total_days_billable_retreated_V2] )