Forum Discussion

Random's avatar
Random
Frequent Visitor
7 years ago
Solved

Identify Consecutive Data?

Hi, I've started creating my first report in Power Bi & have managed to create all the visuals & measures I need except for one & would like to know if I can achieve what I want with Dax or whether I...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Random

    Add a measure

    count_flag = CALCULATE(COUNT(Sheet7[Mark]),FILTER(ALLEXCEPT(Sheet7,Sheet7[StudentRef],Sheet7[RegisterNo]),[flag]=1))

    add this measure in the Visual level filter, select "show items when value is 3"

     

    Best Regards

    Maggie

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

Hi Random

Add a measure

count_flag = CALCULATE(COUNT(Sheet7[Mark]),FILTER(ALLEXCEPT(Sheet7,Sheet7[StudentRef],Sheet7[RegisterNo]),[flag]=1))

add this measure in the Visual level filter, select "show items when value is 3"

 

Best Regards

Maggie