Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
DAX Doubt 1: In the below screenshot, I don't want the extra duplicate to appear. That's My Main requirement in DAX.
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?
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]
Solved! Go to 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.
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.
User | Count |
---|---|
54 | |
23 | |
19 | |
18 | |
17 |
User | Count |
---|---|
91 | |
87 | |
47 | |
28 | |
22 |