find a value from dim table based on a flag in fact table

[KV2022]

Hi, please help

I have to find a value in dimsension table based on a flag value in fact

for eg  if fact[flag] = 1, get 1 scalar value dim[column]

[Anonymous]

Hi @KV2022 ,

You can create a parameter to filter, like this:

I'm not sure if this can meet your needs, if I misunderstand your question, please let me know in time.

Best regards,

Community Support Team Selina zhu

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

[KV2022]

HI, I am not using any slicer in my report. I need a tablular report to show all the values. Then pivot it for summarised values. thanks 

[KV2022]

Hi, thanks for the reply. But I can't create a column. 

[Anonymous]

Hi @KV2022 ,

It is not a column, it just a parameter used to filter your table. 

Would you prefer to use measure?

Best regards,

Community Support Team Selina zhu

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

[KV2022]

thanks for the reply. But I have not tried using the parameter. I have a question based on the same scenario. Supposedly i am getting a single value. But i have to repeat the same value for all the rows. I have to find the stage name which is the current stage from a look up table based on the current flag = y, but have to repeat the same value for all the rows in ID without filtering on the stage.

key  stage   iteration currentflag  

==================

1    stage1    1      N

1    stage2    1      N

1    stage1    2      Y

2    stage1   1      N

2    stage 1   2     N

2    stage2    1      Y

Because I have display a matrix visual like  

ID    current stage  

-------------------

[amitchandak]

@KV2022 , Just create a measure

countrows(filter(Fact, fact[flag] = 1))  and plot it in a visual with dim[column]

[KV2022]

thanks. But my output should be

measure name = dim[value] for fact[flag] = 1 by filtering the fact table for one flag value