Two DAX Doubts | Removing Extra Repeats & Blanks

[ATULSBHATT]

DAX Doubt 1: In the below screenshot, I don't want the extra duplicate to appear. That's My Main requirement in DAX.

Removing extra repeats

DAX Doubt 2: Same Measure When I view with respect to Models, I get Multiple Blanks (As shown in Below Screenshot), I want the blanks to Disappear Is there any method to remove those extra blanks or remove the duplicates as shown in the below pic?

Extra Repeats

Measure Formula: CR% = DIVIDE (CALCULATE( SUM(Sales[Qty]), 'Product'[Category] = "Headphones"), CALCULATE( SUM(Sales[Qty]), 'Product'[Category] = "Mobile"), BLANK())

Purchase Qty is a Column, Only CR% is the Measure.

1st Pic: I want to see the same view, but without the repeat column that I highlighted in yellow.

2nd Pic: Same Measure CR%, I am viewing in a Different view/granularity. But I don't want the Blank Repeat Rows As Highlighted in yellow. Both are Matrix Visuals in Power Bi, I am viewing the same Measure CR%, In Two Different Matrices[Two Different Views/Granularity]

[v-jialluo-msft · Accepted solution]

^{Hi @ATULSBHATT ,}

^{The first question can hide him by changing the line width.}

^{(1) Turn off text wrap}

^{(2) Hide columns}

^{The second question is that the data cannot be reproduced here, and a sample file can be uploaded to further solve it.}

^{Best Regards,}

^{Gallen Luo}

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}