Forum Discussion

feralvarez994's avatar
feralvarez994
Helper II
4 years ago
Solved

Help with model

Hi everyone! I have an issue i think with the model, but for sure you gonna know better than me   The thing is, i want to create a visualization (horizontal bar chart) with the number of bookings (...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi feralvarez994 

    try to CROSSFILTER the relationship between AUTOS table and the BUCFIN table to "BOTH"

    _Contar autos = VAR autoos = CALCULATE ( COUNT ( AUTOS[AT_COAUTO] ), CROSSFILTER ( AUTOS[AT_COAUTO], BUCFIN[BUC_COAUTO], BOTH ))
    RETURN IF ( ISBLANK ( autoos ), 0, autoos )

     

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Hi feralvarez994 

try to CROSSFILTER the relationship between AUTOS table and the BUCFIN table to "BOTH"

_Contar autos = VAR autoos = CALCULATE ( COUNT ( AUTOS[AT_COAUTO] ), CROSSFILTER ( AUTOS[AT_COAUTO], BUCFIN[BUC_COAUTO], BOTH ))
RETURN IF ( ISBLANK ( autoos ), 0, autoos )

 

feralvarez994's avatar
feralvarez994
Helper II
4 years ago

thanks bro, you are amazing!