How to get value to show for one row

[mich32]

Hi there,
I would like to get the mesaure that I created to only be show for Indicator A only (in BOLD).  As you can see the measure repeats for the other indicators, but this is not the result I need (and I put a strikethrough through them).  I provided the DAX that I used to get my total count for the last 12 months.  Thank you community!

Indicator	Pts Avail	Excel Is	Count for last 12 months
A			7191
B	1	≨ 1.00	7191
C	2	0	7191
D	3	≨ 20.0	7191
E	4	0	7191
F	5	≩ 80	7191
G	6	≩ 95	7191
H	7	0	7191

Count for last 12 months =

CALCULATE(COUNTA('Result Table'[Tickets #]),

DATESINPERIOD (

'Result Table'[REPORTDATE],           -- returns period from date column

MAX('Result Table'[REPORTDATE]), -- starting from MAX date

-364,                                                -- shifting it back 364 intervals

DAY                                                 -- each interval being a month

)

)

[mich32 · Accepted solution]

For the community's knowledge, I solved this by selecting Show Items with No Data in the Indicator column on the Visualization pane.

[v-stephen-msft]

Hi @mich32 ,

Try adding an IF judgment statement. For example, if you want a measure,

IF(MAX('TableName'[Indicator]) = "A", ..., ...)

If you want a calculated column,

IF('TableName'[Indicator] = "A", ..., ...)

Best Regards,

Stephen Tao

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

[Ashish_Mathur]

Hi,

Your question is not at all clear.  Share some data, describe the question and show the expected result.