Forum Discussion

santhoshacc's avatar
santhoshacc
Frequent Visitor
7 years ago

Help me on the below query

Hi ,   Kinldy help me  on this query.     I am trying to get the all rows which under date range. I am using the below query  it not shoing any result.   Result = CALCULATE( COUNTROWS(TimeSli...
Reports
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi santhoshacc,

 

If you put the date column in the slicer, you can create a measure simply like below: 

 

Measure = CALCULATE(COUNTROWS('Table1'),ALLSELECTED(Table1))
 

 

Best Regards,
Qiuyun Yu 

  • santhoshacc's avatar
    santhoshacc
    Frequent Visitor
    7 years ago

    Hi ,

     

    Thank you !

     

    But i am takeing the  value of the all , year ,month,day  from slicer (means 3 slicers: 1.yearvalue 2. month value , 3.day value.

     

    i need send to these three value as date ,then i will get the result by using date.

     

     

    Result = CALCULATE(COUNTROWS(TimeSlicer),filter(ALL(TimeSlicer), DATESBETWEEN(
     
    (TimeSlicer[Date]),

    DATEVALUE(date(SELECTEDVALUE(TimeSlicer[Year]),SELECTEDVALUE(TimeSlicer[Month]),SELECTEDVALUE(TimeSlicer[Day]))),


    DATEVALUE(DATE(SELECTEDVALUE(End_TimeSlicer[EYear]),SELECTEDVALUE(End_TimeSlicer[EMonth]),SELECTEDVALUE(End_TimeSlicer[EDay]))))))

     

    Thanks,

    Santhosh.

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Icon for Community Support rankCommunity Support
      7 years ago

      Hi santhoshacc,

       

      Not sure what you mean. The measure provided before can work with three slicers. Please see attached pbix. 

       

      Please share your sample pbix file and tell us your desired output. 

       

      Best Regards,
      Qiuyun Yu