The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a data like this..
.
Report is created on matrix visual like this...
Measure for countvalue is
Solved! Go to Solution.
@Anonymous , Try a mesure like
countvalue % = divide(CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter('Sheet1','Sheet1'[ENDORSEMENT]=0 )),CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter(allselected('Sheet1'),'Sheet1'[ENDORSEMENT]=0 )))
@Anonymous , Try a mesure like
countvalue % = divide(CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter('Sheet1','Sheet1'[ENDORSEMENT]=0 )),CALCULATE(DISTINCTCOUNT('Sheet1'[Policy]),filter(allselected('Sheet1'),'Sheet1'[ENDORSEMENT]=0 )))