Forum Discussion

aggiebrown's avatar
aggiebrown
Icon for Helper III rankHelper III
5 years ago

Turning text measure into value DAX

Need help with a simple measure (I think)    New to DAX (swtiching from EXCEL Formulas gives me a bit of a headache.   [Cancellation buckets] is a measure, not a table. Due to Dataset Size, I am...
Need Help
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
5 years ago

Hi aggiebrown ,

Just write the simliar formula like this:

A =
VAR tab =
    ADDCOLUMNS (
        ADDCOLUMNS ( 'Table', ">30&&<60 Days", [Budgets] ),
        "tag",
            IF ( [Budgets] > 30 && [Budgets] <= 60, 1, BLANK () )
    )
RETURN
    COUNTX ( tab, [tag] )

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

aggiebrown's avatar
aggiebrown
Icon for Helper III rankHelper III
5 years ago

Hey,

 

This measure does not work on my dataset. I have created a sample, with the relationships I currenlty have in place.

 

The desired look is to drill down to how many Ret plans there were, out of which how many cancelled, and cancelled ones bucketted in 3 different groups, however that calc does not work. I think it's because my first two measures are Cross Filtering the two tables and it should follow the same process right?

Example Data File