calculation help

[Gopinath_iyer]

Hi All,

Date	Number
19-Sep-22	100
19-Sep-22	100
19-Sep-22	102
20-Sep-22	103
20-Sep-22	103
20-Sep-22	103

Number

100

102

104

105

I want to create a visual by comparing the above tables

there will be a date filter, so when "19-Sep-22" is selected the visual should show

Number

104

105

and "20-Sep-22" is selected it should show

Number

100

102

104

105

can this be achieved?

regards,

Gopi

[Jihwan_Kim · Accepted solution]

Hi,

I suggest having a disconnected table like below, and put the measure (below) into the Visual Filters Pane.

Please check the below picture and the attached pbix file.

Filter pane measure: =
IF (
    COUNTROWS (
        FILTER ( Number, NOT ( Number[Number] IN DISTINCT ( Data[Number] ) ) )
    ) = 0,
    0,
    1
)

[Anonymous · Accepted solution]

Hi @Gopinath_iyer ,

Check this formula:

Measure = IF(SELECTEDVALUE('Table (2)'[Number]) in DISTINCT('Table'[Number]),1,0)

Best Regards,

Jay

[Jihwan_Kim · Accepted solution]

Hi,

I suggest having a disconnected table like below, and put the measure (below) into the Visual Filters Pane.

Please check the below picture and the attached pbix file.

Filter pane measure: =
IF (
    COUNTROWS (
        FILTER ( Number, NOT ( Number[Number] IN DISTINCT ( Data[Number] ) ) )
    ) = 0,
    0,
    1
)