Forum Discussion

alir22456's avatar
alir22456
Helper I
2 years ago

Export Visual to CSV

Hi, I have created a Table viusalization in my Power BI report. The table consists of a list of names of customers. I did export the visualization to csv, but the measure name was also exported alon...
Need Help
sroy_16's avatar
sroy_16
Resolver II
2 years ago

Hi alir22456 

Please try using this modofoed DAX and see if it works.

Cohort =
VAR __tmpTable1 =
GENERATE(
DISTINCT('Table'[Customers]),
EXCEPT(
DISTINCT('Table'[Services]),
CALCULATETABLE(DISTINCT('Table'[Services]))
)
)
VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
RETURN
__tmpTable3

 

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

  • alir22456's avatar
    alir22456
    Helper I
    2 years ago

    Hi sroy_16 

    Encountering the following error:

    a table of multiple values was supplied where a single value was expected.