Forum Discussion

Gopinath_iyer's avatar
Gopinath_iyer
Helper II
3 years ago
Solved

calculation help

Hi All,

DateNumber
19-Sep-22100
19-Sep-22100
19-Sep-22102
20-Sep-22103
20-Sep-22103
20-Sep-22103

 

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

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    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's avatar
    Anonymous
    3 years ago

    Hi Gopinath_iyer ,

     

    Check this formula:

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

     

    Best Regards,

    Jay

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    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's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Gopinath_iyer ,

     

    Check this formula:

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

     

    Best Regards,

    Jay