Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello. I have strange issue. I have stacked chart with X-axis - Date and Y-axis a Measure where I count documents number with two different filters and divide them. The problem is that, the chart does not recognize that for a COUNTRY i do have blanks but, the chart do not exclude them even if I put the measure in pane filter with "IS NOT BLANK". I need to recreate that logic where Power Bi can calculated for each country the measure and can exclude the blanks from the chart view. I`m using direct query for this report. Is not possible to switch to Import
measure -
Measure 1 - CALCULATE(SUM('Chart Table'[Value]), 'Chart Table'[Value2] = "X")
Measure 2 - CALCULATE(SUM('Chart Table'[Value]), 'Chart Table'[Value3] = "X")
@Steels_Cat , please share your measure
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |